Get rid of security warning
 

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

Get rid of security warning
 

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,

--
Regards,
Tom Ogilvy

"EllenM" wrote:

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

Get rid of security warning
 

On Mar 2, 11:07 am, EllenM wrote:
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.

Get rid of security warning
 

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

EllenM wrote:

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

--

Dave Peterson

Get rid of security warning
 

Thanks, Tom. It worked!!!

"Tom Ogilvy" wrote:

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,

--
Regards,
Tom Ogilvy

"EllenM" wrote:

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

Get rid of security warning
 

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

"Dave Peterson" wrote:

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

EllenM wrote:

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

--

Dave Peterson