VB code based on time/day

[shanec7401]

Hi
I am looking for VB code which will go to a certain cell in a separate worksheet depending on the day and time. In my file I have 3 worksheets.
After a specified idle time of say 90 seconds I want to switch to sheet 2.
Depending on the day and time I want to go to a specific cell in sheet 2.
Example
Between 08:00 and 20:00 Monday go to cell A1
Between 20:00 Monday and 08:00 Tuesday go to cell A139
Between 08:00 Tuesday and 20:00 Tuesday go to cell A227 etc

can anyone shed any light on this?

thanks

 

[shanec7401]

any ideas guys?