Automatically open Excel file set to "Enable Macros"

L

Lisa M

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?
 
H

Harlan Grove

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?
Click to expand...

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.
 
G

Gord Dibben

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
 
L

Lisa M

Thanks very much....
--
Lisa M


Gord Dibben said:
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
Click to expand...
 
Top