Delete Macro

  • Thread starter Thread starter saturnin02
  • Start date Start date
S

saturnin02

Hi,
How do I COMPLETELY delete a macro so that there is NO TRACE of if and the
"Disable/Enable" prompt does not open up each time I try to open up the
workbook?

(I want the prompt on workbooks that DO contain Macros--but NOT after I have
deleted them--using the Tool/Macro/Delete Macro.....

Tx a lot.
S
 
Hi
you also have to delete the module which contained the macros. Open the
VBA editor (ALT+F11) and delete the modules manually. Save the
spreadsheet and it should work

Frank
 
Open the wb, press Alt +F11, find the module in the project pane to the
left,
right click it,select remove and when prompted to export say nay.
Press Alt + Q, save the wb..
 
Tx to both of you for your replies.
I have already done this.....
It ususally does the trick but not here for some reason....
What to do?
 
So you have no more modules in your wb? Then you must have some remnants of
a macro in the ThisWorkbook module or the sheet modules (right click sheet
tab select view code), delete any code that is left there and save the wb.
 
I agree with you but I cannot find what I need to delete.
I have done the right click on the tab and View code but to no avail.
Can you perhaps be more specific...?
Tx,
S
 
HI,
I don;t actually know HOW to run the macro you refer to.
HOw do I actually DO it--where do I copy and paste the code on the web site,
etc.
Tx,
S
 
Well, I tried to copy and paste the code on the web site you mentioned but
it bogs down. (Perhaps I didn;t do it properly).
How in the world can I get this workbook CLEANED of code...?????
S
 
Found it!!!
I found it under "this Workbook"--I mean there was a bit of code left
there--I deleted it and everything is fine now.
Tx to all that replied,
S
 
Back
Top