Search results

Thank you for the updated version. Since I am using this code in multiple workbooks and each workbook is on a seperate monitor, I noticed that once I navigate way from the workbook on the second monitor, the code stops working in that workbook. How do I get the code to run if it is not the...

After working through it this afternoon, I figured out that a nested IF statement inside the Loop worked to check to see if the worksheet was active before executing the rest of the code inside the loop. This stopped the Loop from cycling through each of the hidden worksheets and only cycling...

Ok, I figured out that I needed to use the term "Activate" versus "Select". Now it moves throughout the worksheets. The problem now is that I want to have the code only move to the next Visible worksheet. Any hidden worksheets should not be shown as they are the analysis layer of the workbook...

Thank you for the code. When I copy and paste it into a new module, I get the following error message on the line that states "Worksheets(i).Select": "Run-time error '1004': Select method of Worksheet class failed. I am using MS Office 2007. Should I be specifically referencing the Worksheet?

I am working on an project that contains several worksheet dashboards within the same workbook. I need a way for the worksheets to automatically change to the next tab after a specified interval (for example switch from sheet1 to sheet2 after 1 minute). This would cause the application to rotate...