set macro security to low does not save the setting

  • Thread starter Thread starter KC
  • Start date Start date
K

KC

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top