Jay

If just for your own computer...........................

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 Thu, 31 Aug 2006 01:51:02 -0700, Jay wrote:

Thanks, Rafeek:

One questions though, would such a change in one workbook affect other excel
applications on a particular machine, or just that one? It appears that this
change would impact all other excel applications as well, correct? I only
need it to be one one application only....



"Muhammed Rafeek M" wrote:

Tools-Macro-Security level set to Low level

"Jay" wrote:

Guys and Gals:

To All the guru's out there, I have a burning question.

It is this; "Is there a way or method for disabling the ugly "Enable Macros"
Pop-Up dialog box from showing, but still "Enable Macros" at the start-up of
the application?

If the answer is "Yes", HOW? If it's "No", then, I'll live with it!

I want to keep it clean looking!

Thanks,...

Gord Dibben MS Excel MVP