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
Bookmarks