Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Office FAQ

Tips and Tricks

Unhide Personal.xls to Edit Macros by LarryDeLaruelle
Posted: 22 Aug 00

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.

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close