Remove Macro in Excel

  • Thread starter Thread starter Tim
  • Start date Start date
T

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.
 
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..
 
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
 
Back
Top