Unhide macro worksheet

J

JoeF

I have created a macro in my personal.xls worksheet. I want to delete the
macro but am getting a message that I need to unhide the worksheet. I cannot
locate the worksheet where the macro is stored and cannot find the command to
unhide it. Help!!!

Thank you very much,
 
F

FSt1

hi
the command to unhide the sheet....
2003
on the menu bar>format>sheet>unhide
2007
Home tab>cells group>Hide&hide>unhide sheet

regards
FSt1
 
G

Gord Dibben

Personal.xls is a workBOOK, not a workSHEET.

To unhide a workbook, go to Windows>Unhide.

Or in 2007 go to View>Unhide

Easier yet is to Alt + F11 to open VBE.

Locate Personal.xls and expand.

Double-click on Module1 to open it.

Find your macro and delete it.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
VBA Coding Help for Beginner 0
Macro to copy table of contents to a new doc 0
CAN'T UNHIDE COLUMNS 7
Disable Unhide 3
Macro Loop 0
personal.xls 2
Select Text to End of Footnote 9

Top