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
doesnt work because I may need to hand this over to someone else and I dont
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?

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?

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

"Gary''s Student" wrote:

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?

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" wrote:

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

"Gary''s Student" wrote:

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?

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?

"JLGWhiz" wrote:

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" wrote:

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

"Gary''s Student" wrote:

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?

Try self-certification:

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


--
Gary''s Student - gsnu200769


"tigoda" wrote:

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?

"JLGWhiz" wrote:

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" wrote:

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

"Gary''s Student" wrote:

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?

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

Looks like Im just going to have to start running it as soon as I get in
and just set a reminder so I dont forget,

Thanks for the help everyone


"Gary''s Student" wrote:

Try self-certification:

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


--
Gary''s Student - gsnu200769


"tigoda" wrote:

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?

"JLGWhiz" wrote:

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" wrote:

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

"Gary''s Student" wrote:

Don't use the Task Scheduler.

Open your Excel app and leave it open. Use an OnTime event to trigger the
9:00 task.
--
Gary''s Student - gsnu200769


"tigoda" wrote:

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
doesnt work because I may need to hand this over to someone else and I dont
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?