Macro security bypass for one application

A

AG

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
 
N

NickHK

Look into signing your VBA code, possibly with SelfCert.exe and
Tools>macro>Security>Trusted Sources.

NickHK
 
A

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
 
N

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro security level 6
Difficulty opening Access from within Excel 2
Code for macro security level 3
Macro/Trust Center Settings 5
Forcing Macros to Run 2
avoiding the need to set Macro security level to Low 4
enabling macros from command line 4
macro security trusted sources 0

Top