Security Warning message - Macros

[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?

 

[Gord Dibben]

Delete the modules that the macros were stored in.

Even an empty module will trigger the macro warning.


Gord Dibben MS Excel MVP

 

[Bob Wall]

What is a module?

 

[Gord Dibben]

A module is where a macro or macros are stored when you generate one.

See Debra Dalglesih's site for more info and how to get rid of the macro warning
after you have deleted macros.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord

 

[Bob Wall]

Thank you. I'm not into VBA yet, and I didn't recognize the term
"module".

 

[Gord Dibben]

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


Gord