Might be easier just to create a SelfCert signature for use on your computer.

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 StartProgramsMicrosoft OfficeOffice Tools and build a selfcert from
there.

When complete and your workbook is open go to VBEditor and ToolsDigital
SignatureChoose.

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

On Wed, 16 May 2007 12:47:02 -0700, Gary''s Student
wrote:

Sub sec()
Application.SendKeys ("%tms")
Application.SendKeys ("%l")
Application.SendKeys "{ENTER}"
DoEvents
End Sub

will set the security level to low. It works by playing against the
standard menu bar:

Tools Macros Security