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