how auto enable macro ?

  • Thread starter Thread starter Maileen
  • Start date Start date
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
 
Hi
set the security level to 'Low' (Tools - Macros - Security').
BUT do you really want to do this?. This is a security FEATURE!
 
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
 
Back
Top