reload quick pick list excel sheet

[andrej]

Hi, I am trying to run the autoreloadquickpicklist sheet an I have a problem. I do not want to reload the sheet at midnight but say ar 3am. so I change the vba to following:


Public triggerQuickPickListReload As Boolean
Public triggerFirstMarketSelect As Boolean

Public Sub loadQuickPickList()
triggerQuickPickListReload = True
Application.OnTime TimeValue("03:00:00"), "loadQuickPickList"
End Sub

the problem is that it does not do anything at all. (I have tripple checked if the macros are enabled, ect.)

any I deas what could be wrong?

thank you.
Andrej

[GaryRussell]

The initial auto reload time is set when the workbook first opens. Did you also change it there?

Select "ThisWorkbook" in the code editor and change the code there to read as follows.

Code: Select all

Private Sub Workbook_Open()
    Application.OnTime TimeValue("03:00:00"), "loadQuickPickList"
End Sub

Close and re-open the workbook after making the change so that the new time is set when the workbook opens.

[andrej]

Thank you Gary, works perfectly. I did not realize the "ThisWorkbook" also holds part of the code.

thank you