Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Security Warning... | Links and Linking in Excel | |||
xla security warning | Excel Programming | |||
Macro Security Warning | Excel Programming | |||
security warning | Excel Programming | |||
ADO Security Warning | Excel Programming |