Enable Macros pop-up

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have been given a spreadsheet file to use to input my expenses. Everytime
I open the file I get asked the question "This file contains
Macros........." then "enable," "disable" and "close."

Is there anyway I can set Excel so that it doesn't ask me this question
every time I open file?

Thanks again
 
Hi
this is a security FEATURE. You could set your security level to low
(goto 'Tools - Macros - Security' to do this). But be aware of the
potential risks doing this!
 
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