Disable Excel Macro Message

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 wrote:

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

Thanks,

Chris

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



Chris wrote:

Dave Peterson wrote:

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

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 wrote:
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 wrote:

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

Thanks,

Chris

Dave Peterson wrote:

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



Chris wrote:


Dave Peterson wrote:


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

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\E xcel\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.



Chris wrote:

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 wrote:
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 wrote:

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

Thanks,

Chris

Dave Peterson wrote:

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



Chris wrote:


Dave Peterson wrote:


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

oops.

I omitted the first line when I copied/pasted.

This was originally posted by Jim Rech.



Dave Peterson wrote:

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\E xcel\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.

Chris wrote:

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 wrote:
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 wrote:

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

Thanks,

Chris

Dave Peterson wrote:

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



Chris wrote:


Dave Peterson wrote:


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

--

Dave Peterson

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

Dave Peterson wrote:
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\E xcel\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.



Chris wrote:

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 wrote:

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 wrote:


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

Thanks,

Chris

Dave Peterson wrote:


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



Chris wrote:



Dave Peterson wrote:



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

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 wrote:

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\E xcel\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.



Chris wrote:

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 wrote:

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 wrote:


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

Thanks,

Chris

Dave Peterson wrote:


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



Chris wrote:



Dave Peterson wrote:



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

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.)

Chris wrote:

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 wrote:

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\E xcel\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.



Chris wrote:

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 wrote:

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 wrote:


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

Thanks,

Chris

Dave Peterson wrote:


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



Chris wrote:



Dave Peterson wrote:



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