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