View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Caladonia
 
Posts: n/a
Default Deleting a macro

Thank you. Glad I found this thread.
I used to delete modules w/o a problem €“ couldn't just now.
Wasn't it easier to locate modules in older versions of Excel?

"Gord Dibben" wrote:
Scott
You must go back into the VB Editor and delete the empty module you created.
ALT + F11
CTRL + r
Select your workbook/project and expand.
Right-click on the module and "remove".
Click "no" when asked to export it.
ALT + Q to return to Excel window.
Save the workbook.

Gord Dibben Excel MVP