Enable macros automatically for a workbook

D

Diane Alsing

I have an excel file that onatins macros. Upon opening the file, I am
prompted to answer if I want to enable or disable macros. I would like to
ALWAYS enable macros & not be prompted to answer this question. Is there a
way to set this up?

Thank you.
Regards,
Diane
 
C

CyberTaz

Hi Diane-

Depending on your version of Excel, go to Tools>Macro>Security and select
Low. Please be aware of the risk as described in the dialog box.

Hope this is useful |:>)
 
G

Gord Dibben

Diane

If workbook just for your own use, see help on "Digital Certificates" and the

Self Cert feature.


Gord Dibben Excel MVP
 
D

Diane Alsing

Thank you

Gord Dibben said:
Diane

If workbook just for your own use, see help on "Digital Certificates" and the

Self Cert feature.


Gord Dibben Excel MVP
Click to expand...
 
D

Diane Alsing

Great - Thanks.

CyberTaz said:
Hi Diane-

Depending on your version of Excel, go to Tools>Macro>Security and select
Low. Please be aware of the risk as described in the dialog box.

Hope this is useful |:>)
Click to expand...
 
Top