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?