My Workbook is stored on a network drive.
When I open the workbook I have it coded to run 4 routines.
The routines and code work fine when it is stored locally, however when the workbook is opened on the network drive I get the 1004 error, specifically:
"Run-time error 1004: Method 'OnTime' of object '_Application' failed"
Is there a way around this?
Public Sub Workbook_Open()
Application.ScreenUpdating = False
Application.EnableEvents = True
Application.Calculation = xlCalculationManual
Application.OnTime Now + TimeValue("00:00:01"), "All_Data_View", , True '<<<< ERROR STARTS HERE
Application.OnTime Now + TimeValue("00:00:02"), "Primary_View", , True
Application.OnTime Now + TimeValue("00:00:03"), "SortByCompany", , True
Application.OnTime Now + TimeValue("00:00:04"), "RowFormat", , True
'Application.ScreenUpdating = True
End Sub
Cheers for any assistance,
nKife
Bookmarks