Editing Personal.xls

  • Thread starter Thread starter Shaver
  • Start date Start date
S

Shaver

Some time ago I copied a macro into the Personal.xls file
so that it would always be available to run. Now I can't
figure out how to edit that macro. I get a message that
says I can't open a macro for editing in a hidden
workbook. But I can't figure out how to unhide the
Personal.xls workbook. I open it but I can't see it or
unhide it. If possible, please email me directly.
Thanks!!!
 
Shaver

Press Alt+F11 and open the VBE. Select the entry for personal.xls in the
project explorer and the modules containing the macros will be below it
 
That worked! Thanks so much Nick.
-----Original Message-----
Shaver

Press Alt+F11 and open the VBE. Select the entry for personal.xls in the
project explorer and the modules containing the macros will be below it

--
HTH
Nick Hodge
Southampton, England
(e-mail address removed)





.
Click to expand...
 
Back
Top