5 Replies Latest reply: Feb 26, 2015 9:11 AM by Danilo Torres RSS

    Trying to Loop through Sheets in a Dashboard Continually

      Hi all,

      Trying to put together a dashboard that contains (e.g. 10 sheets) each with different content.

      I'd like to have a sheet with a button that kicks off a loop that displays each sheet for (e.g. 10 seconds) and then moves on to the next one.

      I've used a little code like this:

      for i = 0 to ActiveDocument.NoOfSheets - 1
      ActiveDocument.Sheets(ActiveDocument.Sheets(i).GetProperties.Name).Activate
      ActiveDocument.GetApplication.Sleep 5000
      next

      But I can't seem to get the desktop client to actually show any page between the first and the last page, let alone get it looping through continually. When I apply the above code to a macro attached to a button, it whirrs away but only displays the final sheet....never showing the intermediate sheets.

      Any ideas?

      Many thanks!

      Nick