vb Code:
Private Sub Workbook_Open() application.ontime Now + TimeValue("00:00:15"), "Switch" End Sublooks like your code runs before the workbook is showing, so various instructions can not work, before workbook showing,What is wrong with my code?
change the timevalue to suit




Reply With Quote