Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Devon, England
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is there an answer? (2000)

    Is there a way to have a button like "flash" all the bottom tabs in an eXcel book without moving off the page that u r on? (ie like if you were to click on the bottom tabs I want it to do it with a click of a button)

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there an answer? (2000)

    Not sure if I quite understand what you mean by flash, but the code below scrolls through the sheets in the workbook and activates each sheet then returns to the original sheet containing the button.

    <pre>Option Explicit
    Private Sub CommandButton1_Click()
    Dim oSheet As Worksheet
    Dim oSheet1 As Worksheet
    Set oSheet1 = ThisWorkbook.ActiveSheet
    For Each oSheet In ThisWorkbook.Worksheets
    oSheet.Activate
    Next
    oSheet1.Activate
    Set oSheet1 = Nothing
    End Sub
    </pre>


  3. #3
    New Lounger
    Join Date
    Aug 2002
    Location
    Devon, England
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there an answer? (2000)

    thanx that is just what I meant!

    It works a treat

Posting Permissions

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