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

|

How to Copy Text to and from the Clipboard in Excel and Access Visual Basic

ByRick

You can record a macro to copy from and paste to the Excel worksheet.  Easy enough.  But what if you have a value in Microsoft Excel VBA that you want to put on the clipboard for another program?  Or you want your code to get text from the clipboard after you copied it there from…

Linear Interpolation in Excel

ByRick

We often need to find a value between or near two other known values. If we do not have a more accurate curve, a straight line will have to do. This is Linear Interpolation (or extrapolation). Excel is a good way to do it. For example, I read our electricity meters weekly. This lets me…

|

Excel Functions You Never Need!

ByRick

Why would I tell you about Excel Functions you will never need?  Well, you might be using them now, and not be aware that there are simpler, more elegant alternatives. Are you using any of these: CONCATENATE, CONCAT, PRODUCT, POWER, DAYS, or DAYS360?  Then read on… CONCATENATE and CONCAT to Join Strings Syntax: CONCATENATE(text1, [text2],…

|

How to Use Objects, Properties, Methods, and Events in Visual Basic

ByRick

This is an excerpt from Microsoft Excel 2000 Visual Basic Help. 1.        Objects and Collections An object represents an element of an application, such as a worksheet, a cell, a chart, a form, or a report.  In Visual Basic code, you must first identify an object.  Only then can you apply one of the object’s…

|

How to Record a Macro in Excel (or Microsoft Word)

ByRick

The easiest way to create a macro is: The instructions below are for Excel. Word is similar, but has its own quirks (and no “Absolute or Relative”). If you want to look at programming basics first, see this previous post. 1.     Recording a Macro Absolute or Relative What does that mean?  When you record Absolute,…

|

A List of the Excel Visual Basic Editor Shortcut Keys

ByRick

While you can pick these Shortcut Keys up from the menus in the Excel Visual Basic Editor, it is useful to have them all in one place. F1                         Help on the highlighted itemF2                         Object BrowserShift+F2               View Definition (Go to highlighted Sub or Function)F3                         Repeat last FindF4                         Display Properties WindowF5                         Run / Continue RunF8                         Single Step…