delete macro

[Guest]

when i press delete switch to delete a macro then message is coming "cannot
edit a macro on hidden workbook.unhide the workbook using unhide command"

can any one help me please!

 

[Dave Peterson]

Use Window|Unhide to unhide the workbook.

Then delete your macro.

Then with the window to that workbook active, window|hide.

Close excel and answer yes to the "wanna save your chances" prompt.

 

[bethyb]

This is exactly what I was looking for - worked great.

Thanks very much for your help!