barbikus1978
New Member
- Joined
- Dec 12, 2019
- Messages
- 4
- Office Version
- 2007
- Platform
- Windows
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...
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...