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

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