Delete Macro

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
 
F

Frank Kabel

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
 
P

Peo Sjoblom

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..
 
S

saturnin02

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?
 
P

Peo Sjoblom

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.
 
S

saturnin02

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
 
S

saturnin02

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
 
S

saturnin02

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
 
S

saturnin02

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
 
Top