Remove Macro in Excel

[Tim]

I have a user who has recorded a macro in Excel, but is
unable to delete it. He doesn't even get the option when
the macro is highlighted. Any ideas? Excel 2000
Professional on Windows XP Professional, all patches to
date (10/10/03).

Thanks.

 

[Peo Sjoblom]

Press Alt + F11, look for the workbooks name in project pane on the left
hand side,
now select the module (looks like a folder) also in the same pane. Right
click it and select remove module, select no when prompted to export it.
Done..

 

[David McRitchie]

Hi Tim,
If you have Event macros you will have to remove the code from within,
but for normal macros you have to remove the entire module not just content.

Chip Pearson has more information and a macro to help with this
Coding for the Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm