disable macro???

  • Thread starter Thread starter graham feeley
  • Start date Start date
G

graham feeley

Hi all, when loading Excel I get the message disable Macros---enable macros.
How do I bypass this window and have macros enabled by default.
Regards
Graham
 
Graham,

Depending on your release of Excel

Tools - Options - General - Macro virus protection: unchecked
Tools - Options - Security - Macro Security: Low

This message normally comes up when you open a file containing macros, not
when you open Excel. It's to warn you there are macros in the file you're
opening.
 
Graham

Before setting your security to "low" which will let every file with macros
open without warning I would investigate the use of Office's Self
Certification tool.

You can create a digital certificate and use that on your VBAProject so only
that file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

Gord Dibben Excel MVP
 
Back
Top