Security Levels in 2003

[Guest]

Hi,

I've scheduled a task to open a spreadsheet which fires off some macros when
it opens. This worked fine in Office 2000 with Security Level set to Low, but
since I've upgraded to 2003, Excel does not allow me to set the security to
low. It always goes back to Medium. This then stops the scheduled task from
running as it prompts the user with the enabling/disabling macros question.

Is this an Excel 2003 problem or are there policies which allow a company to
define the minimum level of security allowed for all their users?

Looks like my other choice is to digitally sign it...

With Thanks,
Chris

 

[David Lloyd]

Chris:

I tried the following code when opening Excel 2003, and then verified that
the security level is set to low.

Set xlapp = CreateObject("Excel.Application")

'Open a new Excel Workbook
Set wkb = xlapp.Workbooks.Add()

'Set the workbook macro security level to low to enable macros
wkb.Application.AutomationSecurity = msoAutomationSecurityLow
xlapp.Visible = True

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,

I've scheduled a task to open a spreadsheet which fires off some macros when
it opens. This worked fine in Office 2000 with Security Level set to Low,
but
since I've upgraded to 2003, Excel does not allow me to set the security to
low. It always goes back to Medium. This then stops the scheduled task from
running as it prompts the user with the enabling/disabling macros question.

Is this an Excel 2003 problem or are there policies which allow a company to
define the minimum level of security allowed for all their users?

Looks like my other choice is to digitally sign it...

With Thanks,
Chris