Delete Macro on Spreadsheet that is Hidden – NOT

Topic

New Reply

I just created a recorded macro in Excel 2007. Just a teeny one. I want to either edit or delete it but I can’t since Excel tells me I have to unhide the spreadsheet. it is available for all worksheets. It is not hidden so far as I can tell. I certainly didn’t hide it.

How do I unhide something that doesn’t show as hidden?

Argh!

Thank you!!

Reply | Quote

Replies

Peggy,

Did you record it to your Personal.xls file? If so when you go into the VBE {Visual Basic Editor} via Alt+F11 select the Personal.xls item on the left {see below} then the Modules item under it. You should then see your recorded macro.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote