Macro Security

[paulas]

I have an Excel 2002 application that I created. I set the security level to
medium. When others open the file, they are not getting the option to enable
the macros. I thought the security was on the file, not on the user? Do I
have to have each user change their security setting to medium or low? (In
the past, I've created other applications and do not remember having this
problem.) Can someone help me with this?

 

[Kassie]

The user has to set his/her security to Medium for this to work.

--
HTH

Kassie

Replace xxx with hotmail

 

[Jan Karel Pieterse]

Hi Paulas,

I thought the security was on the file, not on the user?

Of course macro security is a user setting, how else would one prevent
malicious code from running?

You can have your code enabled on systems with macro security set to high. It
requires you to sign your code with a (purchased) digital signature, e.g. from
verisign. You can also create your own certificates, but other users will not
be able to use your code when their security is set to high, unless they have
installed your signature on their system, see:

http://msdn.microsoft.com/en-us/library/aa163622.aspx

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com