Results 1 to 3 of 3

Thread: Want to switch between sheet's automatic.

  1. #1

    Want to switch between sheet's automatic.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want this macro to switch between sheet's with a time interval between each sheet and shall go in loop.

    Sub Macro3()
    ' Macro3 Macro
    ' Keyboard Shortcut: Ctrl+Shift+L


    End Sub

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Why would you want to do that?

  3. #3
    Want to use a monitor that can display graphs that are in different worksheets automatic.

    Came across this VBA code, but it will not update every 5 minutes (refresh in the background)

    Sub TabShow()

    Dim i As Integer
    Dim Pause As Double

    Pause = 15 'Pause delay in seconds
    Loops = 30 'How many loops do you want to do

    For j = 1 To Loops

    For i = 1 To Worksheets.Count

    If Worksheets(i).Visible = "False" Then GoTo 10 'Checks for Hidden worksheets and skips if hidden
    Worksheets(i).Activate 'Select the next worksheet

    x = Timer
    While Timer - x < Pause 'This does the pausing
    10: 'This is just a place marker
    Next i
    Next j

    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts