Enable Macro and ActiveX settings

[gstylianou]

Hi all
Is there a way to enable the Macro settings and ActiveX in Ms Access using vba?

Thanks in advance

 

[Isaac]

Search the forum for Trust Center , lots of recent discussions.

 

[gstylianou]

Search the forum for Trust Center , lots of recent discussions.

Hi, about to enable the macros i found on web the following code, but i don't know why it doesn't work. The VBAWarnings : 1 its for Enable, 2,3,4 for disable macros....

any idea?

Dim WshShell As Object
Set WshShell = CreateObject("WScript.Shell")

WshShell.RegWrite "HKEY_USERS\S-1-5-21-113387354-4276480215-1281312295-1001\SOFTWARE\Microsoft\Office\16.0\Access\Security\VBAWarnings", "1", "REG_DWORD"

This is my access version (2019) path
Computer\HKEY_USERS\S-1-5-21-113387354-4276480215-1281312295-1001\SOFTWARE\Microsoft\Office\16.0\Access\Security\VBAWarnings

 

[arnelgp]

to Enable macro is add your db location to Trusted location.

Adding Trusted Location to Access Run Time

I have created a Microsoft Access file. How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?

stackoverflow.com

 

[gstylianou]

to Enable macro is add your db location to Trusted location.

Adding Trusted Location to Access Run Time

I have created a Microsoft Access file. How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?

stackoverflow.com

Hi, tried many things without any result. Yes, my DB is on trusted location......

 

[Isaac]

It might be reverting due to a group policy or other IT rules on your machine?