Enable macros automatically for a workbook

G

Guest

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
 
G

Guest

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
 
G

Guest

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 |:>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top