Connected sheets not updating

Hello,

The Update Values button I mean is this:Attachment 292573 The top right button.

How you have just described how the Log gets updated is exactly how it is updated. Because of the issues of shared workbooks, I haven't 'shared' it.

I have changed my settings as per your instruction, then closed the workbook and reopened it to insert the code. The Macro has been created and I have inserted the specific cells needed on there (I hope this was the correct step to make!)

I am now receiving this error, but I have no idea why.CaptureMacroError.PNG



Apologies for the rushed response of this message. I hope it's not too hasty that it's uncomprehensable. I'm at work and have nearly finished, this is the only place I can access these files .

Option Explicit
Sub UpdateFromLog()
    Application.DisplayAlerts = False
    If Range("H2") = "Y" Then End
    Workbooks.Open Filename:="T:\O\Op Info\NICCI HARROW\ACCOM SUPPORT\NEW ACCOM LOG 2014.xlsx", Notify:=False
    ActiveWindow.Close
    Call OnTimeMacro
    Range("Stop") = "N"
End Sub
Sub OnTimeMacro()
    Application.OnTime Now + TimeValue("00:" & CStr(Range("H1")) & "00:"), "UpdateFromLog"
    
End Sub
Sub StopUpdate()
    Range("Stop") = "Y"
End Sub

Kristian

Hi,

Just going out for the evening but try correcting that line to

Application.OnTime Now + TimeValue("00:" & CStr(Range("H1")) & ":00"), "UpdateFromLog"

note the semicolon before the last 00 rather than after.