Automatically open Excel file set to "Enable Macros" Lisa M 23.08.2006 21:46:02 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

Re: Automatically open Excel file set to "Enable Macros" "Harlan Grove" <hrlngrv[ at ]aol.com> 23.08.2006 22:18:18 Lisa M wrote... [Quoted Text] >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.

Re: Automatically open Excel file set to "Enable Macros" Gord Dibben <gorddibbATshawDOTca> 23.08.2006 22:39:47 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 <LisaM[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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?

Re: Automatically open Excel file set to "Enable Macros" Lisa M 24.08.2006 01:07:02 Thanks very much.... -- Lisa M "Gord Dibben" wrote: [Quoted Text] > 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 <LisaM[ at ]discussions.microsoft.com> > 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? > >