Automatic sheet switcher based on time

Hello.

We use excel as a production result presentatiation. In the same workbook we have many sheets which we would like excel to automatically switch between and loop through.

Example:

Sheet A : 10 seconds
Sheet B: 10 seconds
Sheet C: 15 seconds
Sheet D: 20 seconds

Then loop and begin again with Sheet A.
Maybe we can have Cell A1 on each sheet which tells how long time this sheet should be visible.
We need to be able to start and stop the looping when we enter edit mode. After leaving edit mode we need to start looping again with a button.

Do anyone have the time to support how to do this in VBA?


/Anders

Fantastic. It works perfect.
I have some sheets I don't want to cycle through. Is it a way to alter the code so that only selected sheets are included in the loop?
I have 8 sheets in total but only want four to be part of the loop.

/Anders

I also got an error when I had two workbooks open. Maybe the code can avoid this by adding the name of the workbook it should loop?