title: Display a sheet with VBA
body: <p>I have a set of sheets on a workbook. I have names of the sheets in a particular column on one of the sheets. This workbook will be displayed on a monitor/dashboard. Is there a way I can loop through the sheets and show them one-by-one.</p>
  <p>Eg, the book has 2 sheets: Sheet1 and Sheet2. When I run the macro, the Sheet1 should be visible on the screen for 5 seconds, then Sheet2 for 5 seconds. Then Sheet1 (loop).</p>
  <p>I am able to add the time delay and loop, however just not able to change display of sheet. I have tried the methods below, but those do not work.</p>
  <pre><code>Application.ScreenUpdating = True
  
  Worksheets(&quot;Sheet1&quot;).Activate
  Worksheets(&quot;Sheet1&quot;).Select
  </code></pre>
  <p>update :</p>
  <p>I have tried all the suggestions, but could not get it to work. When I run the code, the sheet display doesn't change. Eg, is my workbook has three sheets Sheet1, Sheet2 and Sheet3 and I write the code to display sheet1 for 10 sec, sheet2 for 10 secs and sheet3 for 10 sec in that order, during execution excel is stuck on the sheet from where I started the macro for 30 secs and displays the final sheet (sheet3). Not sure if this is because of some settings in the code/application.</p>
  <p>Anyway, since this is not working, I have decided to copy the charts from Excel to a PowerPoint (by VBA) and use the ppt to display on the dashboards. I have used the code provided in the below link.</p>
  <p><a href="http://peltiertech.com/Excel/XL_PPT.html" rel="nofollow noreferrer">http://peltiertech.com/Excel/XL_PPT.html</a></p>