Enable all macros from VBA

[MrNooby]

Whoever uses my application gets security warning and can't run macros. The solution is to go to "Trust center" and then select "Enable all macros" but is there any way to do this in VBA script, so that users doesn't have to open access first and search for those settings and after that they can open my application...?

 

[Trevor G]

I would ask your system administrators as this should have been picked up before installing Office on all PCs.

They maybe able to use an admin patch to sort for you.

 

[MrNooby]

I found a post from Avelino who wrote that this setting is stored in register, so I now added registry change in installation and this works

 

[Trevor G]

Excellent news.