Enable all macros with VBA

[ppataki]

Dear All,

In Trust Center settings there is an option group where user can enable/disable macros (there are like 4 options)

My question would be: how can I toggle these options through VBA? (so without going to Trust Center and enabling them manually)

Many thanks in advance

 

[ghudson]

How will the code you want to create be able to run to alter the user's trust center settings if macros and code are disabled because of the user's trust settings for their computer?

 

[SOS]

To go with ghudson's answer -

a simple - YOU CAN'T. That is the point of that selection - to keep macros or code from running.

 

[Avelino]

Hi everyone

The macro options are changed by the Windows registry

HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0 \ Access \ Security \ VBAWarnings

Manually change the options of the macro is back to the Windows registry to see the value of VBAWarnings

Now just use a script to change the value of this key

Learn also about CurrentProject.IsTrusted (see google or here in the forum)

Success

 

[ppataki]

Thank you Avelino, that works really fine!!

 

[wolfstander]

thank you
is it works in access 2010?

 

[ppataki]

it works, but first you need to check the version number in the registry, I think for Access 2010 it will be 13.0 instead of 12.0

 

[Galaxiom]

Access 2010 is version 14.

For some reason they skipped Access 13.

 

[John Big Booty]

Access 2010 is version 14.

For some reason they skipped Access 13.

Perhaps the developers where Triskaidekaphobic?

 

[Dairy Farmer]

The macro options are changed by the Windows registry

Assuming the Windows user account that opens the app as the required permissions to change the registry. Easy when a computer is part of a network as this can be done from the server.

How to set or change registry editing permissions in Windows XP or in Windows Server 2003

And/or the AV solution installed allows changes without 3'000'000 popups everytime the app is opened and closed.

 

[boblarson]

Perhaps the developers where Triskaidekaphobic?

Nope, but they were mindful that some of their customers might be and so they did it that way (info straight from the developers themselves when I was at the Access Dev Kitchen back when they were still quite a ways from release).

 

[John Big Booty]

Nope, but they were mindful that some of their customers might be and so they did it that way (info straight from the developers themselves when I was at the Access Dev Kitchen back when they were still quite a ways from release).

Thanks for the considered response to what was nothing more than a facile remark

 

[boblarson]

Thanks for the considered response to what was nothing more than a facile remark

Sometimes reality comes out of levity.

 

[sjscrogg]

I see VBAWarning is equal to 1. What value should I see to enable all macros?

 

[boblarson]

I see VBAWarning is equal to 1. What value should I see to enable all macros?

This is how it should be done (the example is for Access 2007 but if you have 2010 just change the 12.0 part to 14.0
http://www.accessjunkie.com/Pages/faq_33.aspx

 

[sjscrogg]

Thanks much. I have 2010. I have determined that I don't have enable issue with anything. Some buttons just do nothing when clicked.
Works on other computers, so I know Access is good.
Any ideas?

 

[sjscrogg]

When I try to add trusted location, error message: "The remote or network path you have entered is not allowed by your current security settings".
???

 

[boblarson]

When I try to add trusted location, error message: "The remote or network path you have entered is not allowed by your current security settings".
???

You can't do that with VBA. You would need to run a batch file to add that. But again, the thing to remember is that there are reasons why this is so difficult to automate. Microsoft has tried to make it extremely difficult for nasty malware to do anything in Windows without you letting it happen. So, just imagine, for a moment, what would happen if you can just change the security settings by some code without user intervention? Just because you aren't trying to install malware doesn't mean that someone else couldn't just use the door you would use. So, again, you really need to have the security settings changed MANUALLY (it can be having a .reg file which the user activates, or batch file which does the adding of it and it needs to run with elevated permissions on Vista and Windows 7).