how can i delete a macro

  • Thread starter Thread starter mcm
  • Start date Start date
M

mcm

I'm currently working on a worksheet which was suppose to not have
macros in it. When I checked whatever macros there were in that
worksheet I noticed that there was one. I tried to delete it but the
'Delete' button is not activated. When I tried to run the macro, excel
returned an error message telling me that the link to this macro cannot
be found or somethin' like that. How can i clean up that macro list in
excel?
 
Go into the VBE (alt+F11), look at the project explore (Ctrl+R), if you have
an entry Modules under your workbook, then expand that and right click on
each module and select Remove. You can decline to prompt to export it.

double click on each entry for sheet
click in the resulting module, do Ctrl + a, then delete key, click the X in
the upper right corner of the module.

do this for the ThisWorkbook entry as well.

Now go back to excel and save the workbook.
 
Hi Tom

While I was able to delete all macros in the workbook,
there is still one 'macro' that can't seem to be deleted.
There are no more modules present in the worksheet but
when I pop up the Tools -> Macro -> Macros window, there
is still one macro remaining but I can't delete or remove
it from the list. When i click 'Run' I get an error
window that says 'Reference is not valid'.

Would appreciate some more advise on this.

Thanks

mcm
 
A vba macro can only exist in a module. You might have an Excel 4 type
macro on a macro sheet.

for each sh in activeworkbook.worksheets
sh.Visible = True
Next

Run the above from another workbook. If should make all sheets in the
workbook visible and expose any macro sheets.

either that, or you workbook might be getting corrupted would be my best
guess.

--
Regards,
Tom Ogilvy

mcm said:
Hi Tom

While I was able to delete all macros in the workbook,
there is still one 'macro' that can't seem to be deleted.
There are no more modules present in the worksheet but
when I pop up the Tools -> Macro -> Macros window, there
is still one macro remaining but I can't delete or remove
it from the list. When i click 'Run' I get an error
window that says 'Reference is not valid'.

Would appreciate some more advise on this.

Thanks

mcm
Click to expand...
 
Back
Top