delete macro
 

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

delete macro
 

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

"Jane Makinson" wrote in message
...
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

delete macro
 

'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).

"Jane Makinson" wrote:

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

delete macro
 

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.



"Paul B" wrote in message
...
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

"Jane Makinson" wrote in message
...
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