Get rid of security warning

[EllenM]

Hello,
I have removed all macros from a particular file. However, when you open
the file, a security warning comes up with the message "c:\file.xls contains
macros." How do I get rid of this warning?

Thanks,
Ellen

 

[Tom Ogilvy]

If you go into the VBE and look at the project explorer window for that
workbook, under Modules, do you see any entries. If so, you need to remove
the modules as well. (right click on the module name in the project explorer
and choose remove)

If you then save the workbook, close it, reopen and still get the prompt,
then

using the project explorer again, open each entry (sheet modules,
thisworkbook module)
Do ctrl+a to select everything in the module, hit the delete key, close
these modules using the x in the upper right of the module window. Save and
close the workbook,

 

[okrob]

Hello,
I have removed all macros from a particular file. However, when you open
the file, a security warning comes up with the message "c:\file.xls contains
macros." How do I get rid of this warning?

Thanks,
Ellen

You *may* still have named ranges in the file. Get rid of them and
see if that does anything for you.

 

[Dave Peterson]

Check out Debra Dalgleish's notes:
http://contextures.com/xlfaqMac.html#NoMacros

 

[EllenM]

Thanks, Tom. It worked!!!

If you go into the VBE and look at the project explorer window for that
workbook, under Modules, do you see any entries. If so, you need to remove
the modules as well. (right click on the module name in the project explorer
and choose remove)

If you then save the workbook, close it, reopen and still get the prompt,
then

using the project explorer again, open each entry (sheet modules,
thisworkbook module)
Do ctrl+a to select everything in the module, hit the delete key, close
these modules using the x in the upper right of the module window. Save and
close the workbook,

 

[EllenM]

Thanks, Dave. Her explanations are quite easy to follow.