application.ontime not working

[barbikus1978]

pls, help me,

i've got this sub:

Sub dashboard()

dTime = Now + TimeSerial(0, 0, 10)

Application.OnTime dTime, "dashboard"
Application.ScreenUpdating = False
Application.DisplayAlerts = False

Call OpenAllAkcurateFiles

End Sub

as U can see, im using application.ontime, BUT... when i start sub OpenAllAkcurateFiles independently (solo), everything is running ok, no problem. When I start sub dashboard(), it still crash on error, than macros is not allowed in this file, BUT again, i allowed macros everywhere in excel, where is it possible (Options, Macro settings, i changed registers in windows, but still no works...

 

[Jeffrey Mahoney]

I believe you must call a different SUB otherwise it is going to repeat itself over and over.

 

[barbikus1978]

I believe you must call a different SUB otherwise it is going to repeat itself over and over.

thanks for reaction, but it doesnt help. i believe, than problem is on different side

 

[RoryA]

What exactly is the error message?

 

[barbikus1978]

hello RoryA,
i will try to translate:

Macro:"path.......\dashboard12122019.xlsm" cannot start. Macro shouldnt be allowed in this sheet or all macros are denied.


Hope, u know which error it is.

 

[RoryA]

Which module is the dashboard routine in?

 

[offthelip]

I believe you must call a different SUB otherwise it is going to repeat itself over and over

You can call the same sub in exactly this way, which is what you need to do when you want to do something regularly, see this thread:Store cell data every 30 minutes

 

[barbikus1978]

Which module is the dashboard routine in?

Perfect, it hepls !!! THX for offthelip, too. This was a problem. It was in module This Workshees, mfckr. I copyied every subs to new Module, and it works. Good job friends..