Hello, I have an Excel file with 4 worksheets that will be projected onto TV screens in my warehouse. I have a macro that will continuously rotate through the spreadsheets and show each of them for 15 seconds before moving to the next sheet. And then once it hits the last sheet and displays it for 15 seconds, it will go back to the 1st sheet and start over (i.e. a continuous loop). This is the code I have so far:
I'd like to have 2 different ways of stopping the loop: 1) after a set amount of time, ex. after 5 minutes, and 2) after a key is pressed in case I need to stop it before the 5 minutes are up. If I stop it by pressing a key, I need it to stop the macro "silently" and not have any error message since it will be projected onto a TV screen for others to view. When I hit ctrl+break or ESC, the macro stops but a "Code execution has been interrupted" message pops up.Please Login or Register to view this content.
I would really appreciate any help!
Bookmarks