Hi
I have an excel macro which when I can open fine on my machine with no
enable macros' prompt. On other machines Excel keeps prompting me
whether I want to enable macros even though on the macro security
option I have set this to low.
When I check this setting it has gone back to medium!
Is there a way to permanently set macro security to low on other users
machines?
Thanks
Kay

You mean you somehow trying to change the Security setting on other machines
with code ?
But it is not working ?

If the user wants the setting at low, they can change it themselves.
Otherwise, bad luck.
Or maybe look into signing your code.

NickHK

"KC" wrote in message
ps.com...
Hi
I have an excel macro which when I can open fine on my machine with no
enable macros' prompt. On other machines Excel keeps prompting me
whether I want to enable macros even though on the macro security
option I have set this to low.
When I check this setting it has gone back to medium!
Is there a way to permanently set macro security to low on other users
machines?
Thanks
Kay

Hi Nick, not even in VBA, on the options menu on all users Excel I am
clicking low security but everytime I open the spreadsheet on the
machines it defaults back to medium which prompts to enable macros -
right pain! I am starting to believe this may be a windows version
option