LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default Why am I getting 2nd macro security warning?

I have a workbook with a "library" of macros. I open and close it
frequently. Since I have macro security set to "medium", I expect and
get the Security Warning diaglog box that says: "<fileName contains
macros. Macros may contain viruses", with Disable and Enable Macros
buttons.

All of sudden, I am now getting an undesired second dialog box with
the title Microsoft Excel. It says: "This workbook contains one or
more Microsoft Excel 4.0 macros. [....] Do you want to enable these
macros?", with Yes and No buttons.

Why am I now getting this second dialog box? That is, what might have
changed? More to the point, what I can do to get rid of it?

Of several workbooks that I have that contain macros, this is the only
one so far that produces the undesired second warning.

I am using and always have used Office Excel 2003. According to my
book, that is synomous with Excel 11, not Excel 4 (same as "4.0"?).

Recently, I did set my macro security to "very high" during some
experiments; and I might have saved the workbook in that state
inadvertently. But since then, I have set the macro security back to
"medium" and saved the workbook.

I use only some standard add-ins, namely the ATP and Solver. That has
not changed for a long time.

I do not believe I have made any changes to the "library" of macros,
which are in Module1. Recently, I did add some test macros in
Module2. I believe I had reopened the workbook without getting the
extra prompt since I added Module2. But honestly, I cannot be sure.

Nevertheless, when I cut-and-paste all of the macros to Module1 and
Module2 of a new workbook, then close and reopen the new workbook, I
get only the first Security Warning, as I expect. I do not get the
undesired second warning.

Moreover, returning to the "bad" workbook, if I remove Module2, the
second Microsoft Excel warning persists. It fact, it persists even
after I deleted all of the worksheets, which referenced some of the
functions, and added a new blank worksheet. Moreover, the undesired
second warning persists after I delete all unnecessary macros in
Module1. Those were test subroutines.

In summary, nothing I do or undo seems to remedy the problem in the
"bad" workbook. But the same macros copied into a new workbook do not
incur the undesired second warning.

Technically, I have already worked around the problem by cut-and-
pasting the macros to new workbook. But I would still like to
understand the situation so that I will know what to do in the future,
when perhaps the work-around will not be that simple.

Thanks for any insights.
 
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
Why security warning still appear after I delete all macros Wei Kai Excel Worksheet Functions 1 February 8th 07 05:51 AM
macro security warning when no maco in workbook Nuts Excel Discussion (Misc queries) 1 March 28th 06 11:21 AM
How to get the security warning, add myself as trusted publisher Judy Excel Discussion (Misc queries) 1 December 19th 05 05:52 PM
Macro/Security Warning Marc Excel Discussion (Misc queries) 3 May 30th 05 10:06 PM


All times are GMT +1. The time now is 12:36 AM.

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"