How to automatically enable a amcro?

  • Thread starter Thread starter athena
  • Start date Start date
A

athena

Hi,

I have a Budget spreadsheet I downloaded once from Microsoft. Each time
I open the worksheet it is asking whether I want to enable a macro it is
using or not. How can I make Excel to accept this macro automatically so
that I do not need to click yes button each time I open it? Thank you.

Cem
 
Athena,

That is the warning that you get when you are opening any workbook that
contains macros. You could change your security level to low, to prevent
the warning, but it's not recommended.
 
Earl Kiosterud shared this with us in microsoft.public.excel:
Athena,

That is the warning that you get when you are opening any workbook
that contains macros. You could change your security level to low,
to prevent the warning, but it's not recommended.
Click to expand...

You could also get a digital signature and sign the macros you trust.
This is the recommended method.
Search the excel help file for "digital signature" for more info.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
Athena

Check out help on Selfcert under digital certificates.

You can certify yourself on your own computer and make the warning go away
without setting security to low level.


Gord Dibben Excel MVP
 
Back
Top