I have an excel application activated by the task scheduler in the middle of
the night
The spreadsheet executes a macro, saves itself and shut down itself.
If the security level is set to low, it works ok
If it is set to medium, thre must be a reply and ...

The macro security level in Excel 2002 seems to be global and the same for
all applications
Is there a way to authorize my application even if the security level is not
low

Thanks

AG

Look into signing your VBA code, possibly with SelfCert.exe and
ToolsmacroSecurityTrusted Sources.

NickHK

"AG" wrote in message
...
I have an excel application activated by the task scheduler in the middle
of
the night
The spreadsheet executes a macro, saves itself and shut down itself.
If the security level is set to low, it works ok
If it is set to medium, thre must be a reply and ...

The macro security level in Excel 2002 seems to be global and the same for
all applications
Is there a way to authorize my application even if the security level is
not
low

Thanks

AG

I tried that after posting my request
It seems to work except for some unexpected error in instructions like a=1
in my macro
Thanks
AG


"NickHK" a écrit dans le message de news:
...
Look into signing your VBA code, possibly with SelfCert.exe and
ToolsmacroSecurityTrusted Sources.

NickHK

"AG" wrote in message
...
I have an excel application activated by the task scheduler in the middle
of
the night
The spreadsheet executes a macro, saves itself and shut down itself.
If the security level is set to low, it works ok
If it is set to medium, thre must be a reply and ...

The macro security level in Excel 2002 seems to be global and the same
for
all applications
Is there a way to authorize my application even if the security level is
not
low

Thanks

AG

Errors in VBA execution should not be related to macro signing etc unless
you are trying to edit the VBA code from VBA code, accessing the .Project.
Is that the case ?

NickHK

"ag" wrote in message ...
I tried that after posting my request
It seems to work except for some unexpected error in instructions like a=1
in my macro
Thanks
AG


"NickHK" a écrit dans le message de news:
...
Look into signing your VBA code, possibly with SelfCert.exe and
ToolsmacroSecurityTrusted Sources.

NickHK

"AG" wrote in message
...
I have an excel application activated by the task scheduler in the
middle
of
the night
The spreadsheet executes a macro, saves itself and shut down itself.
If the security level is set to low, it works ok
If it is set to medium, thre must be a reply and ...

The macro security level in Excel 2002 seems to be global and the same
for
all applications
Is there a way to authorize my application even if the security level
is
not
low

Thanks

AG