how do I edit personal macro in excel

[MaryWilliams]

This has been baffling me for years. To use a macro in all my worksheets, I
save it as a personal macro. But then if I want to edit it, it says "cannot
edit a macro on a hidden workbook. Unhide the workbook using the unhide
command"
Does anyone know where this workbook is and what it might be called?
Appreciate your help. Using office 2003
Mary

 

[Mike Glen]

Hi Mary,

This newsgroup is specifically for matters dealing with Microsoft Project.
I suggest you try to find a more appropriate newsgroup that deals with Excel
problems.

Could you please tell us what led you to chose this newsgroup? We would
really like to know!


Mike Glen
Project MVP

 

[JulieD]

Hi Mary

a better group to post in would be
microsoft.public.excel.programming
or
microsoft.public.excel.misc

however, to answer your question - personal.xls is opened automatically as
a hidden file when you start excel, to unhide it choose windows / unhide
....just don't forget to hide it again after chaning your macro. Just a note
though, you can change the macro without unhiding personal - open a
workbook, press the ALT & F11 keys at the same time and you will end up in
the VBE window, on the left (in the project explorer) you should be able to
see (Personal.xls) - under that should be a folder called Macros and your
macros will be in here.

Hope this helps
Cheers
JulieD