Disable Excel Macro Message

[Chris]

Is there a way to disable the Enable/Disable Macro message on a workbook
containing a macro so that any user opening the workbook will not be
prompted with that message?

Thanks,

Chris

 

[Dave Peterson]

There's a setting that each user can change -- but you can't do it for them in
your workbook.

Tools|macros|security|security tab is where they'll find it.

 

[Chris]

There's a setting that each user can change -- but you can't do it for them in
your workbook.

Tools|macros|security|security tab is where they'll find it.

If it's changing the security level to low, that's not working. Any
other ideas?

Thanks,

Chris

 

[Dave Peterson]

You changed this setting on a user's pc and they still got the message????

 

[Chris]

Yes it still comes up I tried it on multiple machines.

Thanks,

Chris

 

[Dave Peterson]

I've never seen any prompt when the setting was on low.

After you change this setting, try closing excel, then reopen excel. Check that
setting once more.

I've seen lots of posts that complain that their IT folks didn't give them
permission to change the registry (for keeps).

If you find that the setting doesn't "stick", I think it's time to ask your IT
folks.

 

[Chris]

I am the IT folks I even rebooted after changing the setting not
that it would make a difference but still no change. If there is a
registry setting that can be changed do you happen to know which it is?

Thanks,

Chris

 

[Dave Peterson]

Where in user profiles - or elsewhere- is this setting saved.

The Excel security setting is saved in the registry under this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security

This is for Excel 2003. Should be something similar for other versions.

The item is "Level". You'd set this to 2 for medium

===

and just to add: 1 = low, 2 = medium, 3 = high.

=======
So the setting reverted back each time you closed excel--just curious.

 

[Dave Peterson]

oops.

I omitted the first line when I copied/pasted.

This was originally posted by Jim Rech.

 

[Chris]

Thanks I'll give that a try and see if it works. No the setting
wouldn't revert back it stayed on low but still gives me the macros
message. We are using Office 2003.

Thanks,

Chris

 

[Chris]

Well no luck it was already set to 1. Oh well my user may just have to
live with it.

Thanks for your help,

Chris

 

[Dave Peterson]

Sorry I couldn't help.

If you've seen this with your own eyes, then ignore this. But I'd watch to see
that warning message. Maybe the user isn't remembering the message correctly.

(Yeah, it's a long shot--but I got nothin' else.)