Allow a macro to run, even if the PC is locked

[kgkev]

i have a rather long routine that I would like to fire off during my lunch break.

I will have the work book open, and I have added the necissary code to the workbook_open event

Application.OnTime TimeValue("13:00:00"), "AFK UPDATE"

However my PC is set to lock after a few minutes due to group policy. This appears to make excel not trigger the event (at least it states that Macros are disables)

Is there any way round this?

using windows 10 and excel 365

 

[Joe4]

What if you place the code in the "Workbook_Open" event, but with NO timer, and then have just Windows Scheduler open the file at the time that you want it to run?
This is how we used to run all of our Scheduled Jobs (we usually did it directly from the server).

 

[kgkev]

Thanks for the reply.

Windows scheduler fails to run the macro as well, I think it because my user account does not have the necessary network privileges to run in a "logged out" state.

I will try with a system admin account locally and see if they works, otherwise it might be necessary to run directly on the server as you suggest.