Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stu Stu is offline
external usenet poster
 
Posts: 29
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I email amacro? leo Excel Worksheet Functions 24 August 9th 06 02:47 PM
How to disable Security Warning for Excel 2003 with NO macros Marjie Setting up and Configuration of Excel 2 November 1st 05 07:19 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
Macro warning box Quaisne Excel Discussion (Misc queries) 4 October 13th 05 07:45 AM
Macro warning window Beema Excel Discussion (Misc queries) 1 December 2nd 04 05:33 PM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"