Assuming no one changes the active workbook to another, the following code should be more secure (though not perfect!)
Sub Refresh()
ActiveWorkbook.RefreshAll
Application.OnTime Now + TimeValue("00:00:20"), "SlidetoTwo"
End Sub
Sub ShowFirstSheet()
Sheets("Dashboard 1").Activate
Application.OnTime Now + TimeValue("00:00:20"), "SlidetoTwo"
End Sub
Sub SlidetoTwo()
Sheets("Dashboard 2").Activate
Application.OnTime Now + TimeValue("00:00:20"), "SlidetoThree"
End Sub
Sub SlidetoThree()
Sheets("Dashboard 3").Activate
Application.OnTime Now + TimeValue("00:00:20"), "SlideToOne"
End Sub
Sub SlideToOne()
Sheets("Dashboard 1").Activate
Refresh
End Sub
Artik
Bookmarks