unhide personal.xls?

[Guest]

When I try to edit a macro that has been stored in personal.xls, it tells me
to unhide the workbook first, then I will be able to edit the macro, however
I can not figure out how to do this. Any suggestions? Thanks

 

[Guest]

You can unhide a hidden workbook using Window;unhide. Another way to get to
your personal.xls macros is to click Alt+F11, which will open up the VB
Editor.

 

[Don Guillett]

windows>unhide>

 

[Guest]

Go to the Window menu to Unhide, then you will be able to edit the macro in
the personal.xls file.

Andrew

 

[Guest]

Thanks all, but my unhide button is greyed out so I can't open it. I can get
to the VB editor but once there, can I insert new actions using a 'start
recording' button or must I enter the commands manually?

 

[Guest]

In VBE you must enter commands manually.

Thanks all, but my unhide button is greyed out so I can't open it. I can get
to the VB editor but once there, can I insert new actions using a 'start
recording' button or must I enter the commands manually?

 

[Don Guillett]

You may record a macro and select the personal.xls to save it to. Look at
your options.
tools>macro>record>store macro in>select personal.xls>when closing you will
be asked to save.