Disable code during certain times and Run another.

[saudi_red_neck]

Hello friends! hope all is well!

Need your kind and amazing help please.

The workbook here has a looping code that goes from one sheet to the other every 5 seconds. All is well here.

I want to disable the code from 1-1:15PM AND 3-3:15PM AND 6-6:15PM.

I want to call a VBA code name RefreshDataBase instead.


Please help & Thank you very much in advance!

[JLGWhiz]

This might work

Please Login or Register  to view this content.

[saudi_red_neck]

Very cool! Thank you. One last question,

Let us instead run the code every hour.
Can we RefreshDataBase with the following code? i.e. is the code below correct? if not please help.

much appreciated!

Please Login or Register  to view this content.

[JLGWhiz]

I don't believe that would run the RefreshDataBase at all. Off hand I can't think of how to tell it to only run RefreshDataBase every hour in your set up, but if I do, I will post back.

[JLGWhiz]

I did not test this, but it seems logical. I used Range("A1") as the storage range, but you can change that in both places to a range that will not interfere with your data. The throry is that When the my macro runs, it will check cell A1 (or the cell you choose) to determine if one hour has lapsed since the last RefreshDataBase and if it has then it will run the macro and put a new time in the storage cell and skips the rest of MyMacro. If one hour has not elapsed, then it runs the rest of MyMacro. You will need to put a starting time in the storage cell to kick it off. After that the code will update the cell. The part I am not sure about is the "1:00:00" but you can test it and see what happens.

Please Login or Register  to view this content.