Editing Personal.xls

[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!!!

 

[Nick Hodge]

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

 

[Shaver]

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)





.