Unhide Personal.xls to Edit Macros

Creating a Macro and storing it in the Personal.xls workbook makes it available to all workbooks.

But, if you want to edit the macro and go to Tools/Macros, select the macro and click on edit you get the message:

"Cannot edit a macro on a hidden workbook. Unhide the workbook using the unhide command."

However, Help does not contain an Unhide item to explain how to unhide the workbook. What to do?

Locate the Personal.xls file on your system. It should be in:

Program Files\Microsoft Office\Office\XLStart

on the drive where you installed MS Office.

Select the file Personal.xls and open it. The Title Bar will show the file name as "BookN" rather than Personal.xls.

Now click on Windows on the Menu Bar then click on Unhide. Select Personal.xls and click on OK.

Now you can go to Tools/Macros and edit the Macro using the VB editor.

This may seem obvious to experienced users of Excel, but as one new to creating and editing macros, it took me a while to figure this out.