Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Security Warning message - Macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Wall - 20 Aug 2007 18:55 GMT
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?

Signature

Via: http://www.jumlers.com/microsoft.public.excel/

Gord Dibben - 20 Aug 2007 19:13 GMT
Delete the modules that the macros were stored in.

Even an empty module will trigger the macro warning.

Gord Dibben  MS Excel MVP

>I have two workbooks, A and B.  Both workbooks had the same macros.
>I later created a Personal Workbook (Personal.xls) for all my
[quoted text clipped - 18 lines]
>How can I get rid of the “Security Warning” message box for
>workbook B?
Bob Wall - 20 Aug 2007 20:59 GMT
What is a module?

Signature

Via: http://www.jumlers.com/microsoft.public.excel/

Gord Dibben - 20 Aug 2007 21:16 GMT
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

>What is a module?
Bob Wall - 20 Aug 2007 22:49 GMT
Thank you.  I'm not into VBA yet, and I didn't recognize the term
"module".

Signature

Via: http://www.jumlers.com/microsoft.public.excel/

Gord Dibben - 20 Aug 2007 23:15 GMT
The fact you were creating and deleting macros gave rise to my assumption that
you knew what a module was.

Gord

>Thank you.  I'm not into VBA yet, and I didn't recognize the term
>"module".
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.