ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro warning even though macros have been removed. (https://www.excelbanter.com/excel-discussion-misc-queries/124433-macro-warning-even-though-macros-have-been-removed.html)

Stu

Macro warning even though macros have been removed.
 
Hello. I have a workbook that used to contain macros. The macros have now
been deleted from the macro box (tools/marco/macros), however, on opening,
the security warning still comes up asking whether or not the user would like
the macros enabled or disabled.

Can anyone advise how I can stop this occuring (without changing the macro
security levels to low)?

Many thanks

Gary''s Student

Macro warning even though macros have been removed.
 
Even though you have deleted the macros, you are still getting the warning
because the modules that held the macros still exist.

Remove the modules as well.
--
Gary's Student


"Stu" wrote:

Hello. I have a workbook that used to contain macros. The macros have now
been deleted from the macro box (tools/marco/macros), however, on opening,
the security warning still comes up asking whether or not the user would like
the macros enabled or disabled.

Can anyone advise how I can stop this occuring (without changing the macro
security levels to low)?

Many thanks


Dave Peterson

Macro warning even though macros have been removed.
 
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

Stu wrote:

Hello. I have a workbook that used to contain macros. The macros have now
been deleted from the macro box (tools/marco/macros), however, on opening,
the security warning still comes up asking whether or not the user would like
the macros enabled or disabled.

Can anyone advise how I can stop this occuring (without changing the macro
security levels to low)?

Many thanks


--

Dave Peterson


All times are GMT +1. The time now is 08:56 AM.

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