delete macro

J

Jane Makinson

Had created macro which is no longer needed and deleted it. But still get
enable/disable prompt when opening files. Have followed instructions
previously given to delete a module (there is nothing in the module) and also
to delete in every object, and this workbook object , in the workbook. There
is no nothing in the module or any object. Still getting enable/disable
prompt. Please, please help. Thanks
 
P

Paul B

Jane, sounds like there is one somewhere, have a look here for details on
where to look for them http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

bpeltzer

'Nothing in the module' points to exactly the problem: there's still a
module. You've got to delete the module(s) to avoid the warning. You can
delete it from w/in the VB Editor (the link Paul provided has more details if
needed).
 
J

Jim May

Although you have "erased the content of the module", that's not enough.
You need also to "Remove" the empty module. In the VBE, click on the module
(in the explorer window, then at the menu, File, Remove... OK
Done.
 
Top