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!

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.

Ankur wrote:

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

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

Thanks very much for your help!