Macro Warning

[Ilan]

When i open up MS Access, i get a message from windows
saying "are you sure you want to open this file, it
contains macros which could be potentially harmful" etc.
how do i turn this message off so i dont see it everytime
i open a file(with macros)?

thanks,
Ilan

 

[Carey Frisch [MVP]]

Security Level Setting Applies to XSL, Smart Documents, and Add-Ins
http://support.microsoft.com/default.aspx?scid=kb;en-us;828384&Product=acc2003

"The Security Level tab in the Security dialog box implies what the security level is for macros.
If the macro security is set to High, running scripts is disabled. If the macro security is set to Medium,
the user is asked whether to run script in these files. If macro security is set to Low, the script is run."

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User

Be Smart! Protect your PC!
http://www.microsoft.com/security/protect/

---------------------------------------------------------------------------------


| When i open up MS Access, i get a message from windows
| saying "are you sure you want to open this file, it
| contains macros which could be potentially harmful" etc.
| how do i turn this message off so i dont see it everytime
| i open a file(with macros)?
|
| thanks,
| Ilan

 

[Ilan]

where do i find this "security box" to change the settings?

Thanks,
Ilan

-----Original Message-----
Security Level Setting Applies to XSL, Smart Documents, and Add-Ins
http://support.microsoft.com/default.aspx?scid=kb;en- us;828384&Product=acc2003

"The Security Level tab in the Security dialog box

implies what the security level is for macros.

If the macro security is set to High, running scripts is

disabled. If the macro security is set to Medium,

the user is asked whether to run script in these files.

If macro security is set to Low, the script is run."

 

[Christine Edwards]

in xl
tools
options
general
macro protection
un tick the box

hope that helps

 

[Ilan]

That was the solution i was looking for!
Thanks Christine.

Ilan