Is there any way in Excel 2003 to set a spreadsheet to automatically open
enabling macros, so the user doesn't get that annoying dialog box?
--
Lisa M

Lisa M wrote...
>Is there any way in Excel 2003 to set a spreadsheet to automatically open
>enabling macros, so the user doesn't get that annoying dialog box?

If there were, don't you think macro virus writers would take advantage
of it?

Your users could set macro security to Low, but that's a bad idea. Or
you could digitally sign the VBA projects in the workbooks you produce,
then configure each of your users' PCs to trust VBA projects with that
signature. Then workbooks with signed VBA projects would open without
the dialog and with macros enabled.

Only by user setting macro security to "low" which is not recommended or by
author digitally signing the workbook.

If only for your own computer you can use Microsoft Office SelfCert tool to
create a digital certificate for use on your computer.

See Help on "digital certificates"


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 14:46:02 -0700, Lisa M <(E-Mail Removed)>
wrote:

>Is there any way in Excel 2003 to set a spreadsheet to automatically open
>enabling macros, so the user doesn't get that annoying dialog box?

Thanks very much....
--
Lisa M


"Gord Dibben" wrote:

> Only by user setting macro security to "low" which is not recommended or by
> author digitally signing the workbook.
>
> If only for your own computer you can use Microsoft Office SelfCert tool to
> create a digital certificate for use on your computer.
>
> See Help on "digital certificates"
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 23 Aug 2006 14:46:02 -0700, Lisa M <(E-Mail Removed)>
> wrote:
>
> >Is there any way in Excel 2003 to set a spreadsheet to automatically open
> >enabling macros, so the user doesn't get that annoying dialog box?
>
>