how auto enable macro ?

M

Maileen

Hi,

When my excel macro starts, it asks to user to tell if he enables macro
or not.
How can i do if i don't want user to answer to this question, but auto
enable macro without any user help ?

thx,
Maileen
 
F

Frank Kabel

Hi
set the security level to 'Low' (Tools - Macros - Security').
BUT do you really want to do this?. This is a security FEATURE!
 
G

Gord Dibben

Maileen

Which version of Excel?

XL97 macro protection is on or off, no levels of security.

Newer versions allow levels of security.

Before setting my security to "low" and running the risk of virus infection, I
would investigate the use of a "digital certificate".

If file is for your use only, check out "self cert" in Help.

You can run Self Cert from the Start>Programs>MS Office>MS Office Tools

Then see Help on "certificates" and "add a digital certificate to a file or
VBA project".

Gord Dibben Excel MVP
 
Top