Security Warning message - Macros

  • Thread starter Thread starter Bob Wall
  • Start date Start date
B

Bob Wall

I have two workbooks, A and B. Both workbooks had the same macros.
I later created a Personal Workbook (Personal.xls) for all my
macros, so that I can use my macros in new workbooks. I even
created a command called “Macros.â€

I removed the original macros from, I think, the workbook I created
most of them in. I can still see the personal macros if I use the
Alt, F, T, M, M, commands; or use the Macros command.

When I load workbook A, it loads quickly. When I load workbook B,
it asks me to “Enable Macros†in the “Security Warningâ€
message box.

Both workbooks have the Security level set at Medium. If I change
the setting to Low in workbook B, I don’t get the “Security
Warning†message box; but I prefer having the level set at Medium.

I’ve tested several other workbooks, and they don’t display the
“Security Warning†message box.

How can I get rid of the “Security Warning†message box for
workbook B?
 
Delete the modules that the macros were stored in.

Even an empty module will trigger the macro warning.


Gord Dibben MS Excel MVP
 
The fact you were creating and deleting macros gave rise to my assumption that
you knew what a module was.


Gord
 
Back
Top