Monthly Archives: September 2008

Automatically Protect/UnProtect All Worksheets

Posted on September 26, 2008 by Admin

Tonight I want to automatically protect and unprotect all Microsoft Excel Worksheets in my Workbook with password, instead of doing it manually, I put these following Excel VBA macro code in my Workbook. Public Sub ProtectAllSheets() Dim objSheet As Worksheet … Continue reading →

How To Hide an Excel Worksheet

Posted on September 24, 2008 by Admin

Some time we want to hide a certain Excel Worksheet from view, and it’s a common practice to use select the Worksheet, go to menu Format > Sheet > Hide. Using the method explained above is right, but unfortunately, others … Continue reading →

Posted in Workbook and Worksheet | Tagged Excel, excel macro, excel vba, excel vba hide all worksheets, excel vba hide column, excel vba hide sheet, excel vba hide worksheet, excel vba hide worksheets, excel workbook, excel worksheet, Hide sheet vba, hide worksheet, hide worksheet vba, Microsoft, microsoft excel, VBA, vba excel hide sheet, vba hide sheet, vba hide worksheet, vba macro, VeryHidden, visual basic editor, Workbook, Worksheet, xlSheetVeryHidden | 7 Comments

Create New Excel Worksheet With VBA

Posted on September 13, 2008 by Admin

The Excel VBA macro below will create a new Excel Worksheet called ‘RawData’ or we can use msgbox to ask for the Worksheet name if needed. If there is already a Worksheet called RawData, user will be ask whether they … Continue reading →

Posted in Workbook and Worksheet | Tagged create new worksheet vba, create worksheet vba, excel macro create new sheet, excel vba create new sheet, excel vba create new worksheet, excel vba new sheet, excel vba new worksheet, vba add worksheet, vba create new sheet, vba create new worksheet, vba excel create new sheet, vba excel create new worksheet, vba excel new worksheet, vba new worksheet, Worksheet | 11 Comments

How To Open Excel File Using Macro

Posted on September 11, 2008 by Admin

Imagine this condition; We are in the middle of doing something using Excel VBA macro, then we want the macro to automatically show the File Open dialog box to make us (user) able to choose another Excel file to be … Continue reading →

Posted in Excel VBA Function | Tagged Dialog Box, excel macro open excel file, excel macro open file, excel macro to open a file, excel open file macro, excel vba open file, macro excel open file, macro open file, macro to open a file, macro to open excel file, Open File, open file macro, open file macro excel, vba macro open file | 16 Comments

Changing Microsoft Excel Status Bar

Posted on September 10, 2008 by Admin

Maybe for some reason we want to change our Microsoft Excel Status Bar, then this simple vba function will do the work for us. The end result will look like this: Ok, to do it, put this following code in … Continue reading →

Posted in Excel VBA Function | Tagged excel status bar, status bar, vba function, vba macro | 6 Comments

Handy VBA To Calculate Person Age

Posted on September 10, 2008 by Admin

This handy VBA procedure is just to show you how we can calculate and display someone Age. To do this, of course we need to know their date of birth first, then simply using datediff and mod vba functions we … Continue reading →

Posted in Excel VBA Function | Tagged datediff, mod, vba function | 13 Comments

Getting Cell Reference With Input Box

Posted on September 9, 2008 by Admin

We can get an input from user using Input Box, but we also can use the Input Box to get the address of cell reference in Microsoft Excel. Using simple Excel VBA procedure below we can ask user to select … Continue reading →

Posted in Excel VBA Function | Tagged Copy, excel vba input box, excel vba inputbox, Input Box, input box vba, input range vba, Paste, vba input range | 158 Comments