Hi,
Im wondering if there is VBA code to make a worksheet activate, wait for a given period and then progress to the next sheet, without using the script Application.Wait?
I need to avoid using this so that any Active X controls i have on the page can update.
I've tried playing with Application.OnTime and using another macro to advance a sheet like Sheets(ActiveSheet.Index + 1).Activate, but i can't seem to get it right.
Any help greatly appreciated.
Im wondering if there is VBA code to make a worksheet activate, wait for a given period and then progress to the next sheet, without using the script Application.Wait?
I need to avoid using this so that any Active X controls i have on the page can update.
I've tried playing with Application.OnTime and using another macro to advance a sheet like Sheets(ActiveSheet.Index + 1).Activate, but i can't seem to get it right.
Any help greatly appreciated.