scheduled tasks

[tigoda]

I have created an excel sheet with macros that run when the sheet is opened,
this sheet need to be opened and the macro run at 9am every morning.

To do this I am going to use scheduled tasks, however, I keep getting the
message asking is I want to allow the macros to be enabled or disabled,

I know I can stop this by setting the macro security level to low which I
have no problem with, But every time the sheet runs the security level is
back to medium and the button has to be clicked.,

even setting myself up and the setting the sheet as a trusted publisher
doesn’t work because I may need to hand this over to someone else and I don’t
want to go messing around with that sort of stuff when I go, and I cant trust
someone else to do the same when its handed on after that

Is there any way to stop this? Is there something that I could put in the
command line of the scheduled task maybe?

 

[Gary''s Student]

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.

 

[tigoda]

thanks, but i cant leave the sheet running all the time,

 

[JLGWhiz]

The only other way to avoid the security messages, that I know of, is to set
your security level to low. If you and/or your Users utilize Virus Scan,
there is some degree of protection against rogue macros.

 

[tigoda]

i have no problem withth esecurity set to low, i have it set to that all
ready,

when scheduled tasks opens it though it has it set to medium

is there nothnig that can be put in the command line of the task like you
can with access?

 

[Gary''s Student]

Try self-certification:

http://support.microsoft.com/?KBID=217221

 

[tigoda]

Some intelligent person on this end appears to have decided were not to be
trusted with SelfCert.exe,

Looks like I’m just going to have to start running it as soon as I get in
and just set a reminder so I don’t forget,

Thanks for the help everyone