ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to disable Security Warning for Excel 2003 with NO macros (https://www.excelbanter.com/setting-up-configuration-excel/53217-how-disable-security-warning-excel-2003-no-macros.html)

Marjie

How to disable Security Warning for Excel 2003 with NO macros
 
We are converting from Excel 2000 to 2003. Previously, if we tried to open a
spreadsheet that did not contain macros, we would not get a security warning
with a medium security level. If I do not have a macro in my spreadsheet,
why must I get the security warning. I would like to disable it.
Thanks,
Marjie

Paul B

How to disable Security Warning for Excel 2003 with NO macros
 
Marjie,
You also have to remove the modules on which the macros were stored have a
look here for details 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


"Marjie" wrote in message
...
We are converting from Excel 2000 to 2003. Previously, if we tried to
open a
spreadsheet that did not contain macros, we would not get a security
warning
with a medium security level. If I do not have a macro in my spreadsheet,
why must I get the security warning. I would like to disable it.
Thanks,
Marjie




Marjie

How to disable Security Warning for Excel 2003 with NO macros
 
Thank you very much. I see the lingering empty modules and can delete them.
That takes care of my problem.

"Paul B" wrote:

Marjie,
You also have to remove the modules on which the macros were stored have a
look here for details 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


"Marjie" wrote in message
...
We are converting from Excel 2000 to 2003. Previously, if we tried to
open a
spreadsheet that did not contain macros, we would not get a security
warning
with a medium security level. If I do not have a macro in my spreadsheet,
why must I get the security warning. I would like to disable it.
Thanks,
Marjie






All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com