I Revealed (Unhid) PERSONAL.XLSB: How do I Hide it Again?

ByRick

If you have saved any macros for general use, you would have saved them in the PERSONAL.XLSB workbook.  This hidden file loads when Excel launches. It is because it is in memory that those macros are always available.  But, as with any hidden file, it is possible to unhide it.  For example, with the View ribbon > Window group > Unhide and OK.  The worksheet part is blank, since the file only exists to store macros.

Now you will always see Personal.xlsb onscreen when you run Excel.  This may not be as much fun as you might have expected.  It may get in the way of other work.  Or you might use that tempting blank worksheet for data, with unexpected results.

Better hide it again!

The quickest way is to go to the View tab again, and use Hide. Now, Personal.xlsb will continue to open, but it’ll be hidden from view. You’ll still have the macros for use at any time.  And you won’t see that pesky blank workbook anymore (thanks to this site for the idea).

Similar Posts

|

Useful Keywords to Know in Excel Visual Basic

ByRick

1.        The Application Keyword Use “Application” to refer to Excel, e.g.: Application.ActivePrinter Name of the Active Printer.Application.Name            Name of the program running (“Microsoft Excel”).Application.Path            The path from which the program is running. 2.        ActiveControl Instead of the name of a specific control (e.g. txtEdit), you can use the keyword ActiveControl.  This will let your program refer…

|

Other ActiveX Controls in Excel Worksheets

ByRick

In an earlier post, we looked at connecting VBA code to command buttons on the Worksheet, the Quick Access Toolbar and the Ribbon.  What about the other ActiveX Controls: The Combo Box, List Box, or Check Box?  How about Option Buttons, the Scroll Bar, Spin button, Toggle button, etc.?  That’s coming up in this post….