Is it possible to suppress the Security Warning Popup for Selected Excel Files

[MCCAFFREY]

My diary is based in excel. It has Macros in it. Is it possible to disable
the Security Warning Pop-up for that single excel file without disabling it
for all other excel files.

TIA

Gerry.

 

[Gord Dibben]

Gerry

You can sign the workbook and get rid of the "enable macros" without changing
security level to low.

For the macros warning, if just for your own use on your computer, you can use
the SelfCert tool to create a certificate that sets the macros in a workbook to
"Trusted" and does not display the macros warning.

Check out Help on Digital Signing and the the Self-Cert utility which allows you
to sign your projects on your own computer only.

Self-cert digital signatures are not exportable as are paid-for ones from Thawte
and Versisign.

Go to Start>Programs>Microsoft Office>Office Tools and build a selfcert from
there.

When complete and your workbook is open go to VBEditor and Tools>Digital
Signature>Choose.

Select the one you just created and Ok your way out.

Save the workbook and re-open. Click "Yes" when asked about "trusted whatever".

You won't see the macro message again for that workbook.


Gord Dibben MS Excel MVP