Hi All
I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the worksheetsautomatically say every 10 minutes and loop back to the first before repeatinguntil the workbook/dashboard is closed, but then restart on opening.
I’m guessing I can record a macro to switch from sayworksheet 1 to worksheet 2 then worksheet 2 to worksheet 3 etc (I can do that),but how, using vba (I assume) can I run the next macro (3to4) 10 minutes later then the next (4to5) thenthe next (5to1), you get the picture.
Thanks in advance for the help you brilliant people provideto us newbies…
Iann W
I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the worksheetsautomatically say every 10 minutes and loop back to the first before repeatinguntil the workbook/dashboard is closed, but then restart on opening.
I’m guessing I can record a macro to switch from sayworksheet 1 to worksheet 2 then worksheet 2 to worksheet 3 etc (I can do that),but how, using vba (I assume) can I run the next macro (3to4) 10 minutes later then the next (4to5) thenthe next (5to1), you get the picture.
Thanks in advance for the help you brilliant people provideto us newbies…
Iann W