Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide and Unhide worksheets using code (2002)

    Sages, I have a workbook with many worksheets. I would like to be able to have

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide and Unhide worksheets using code (2002)

    I would have used a button on the toolbar to trigger the code, but if you want to do it this way, then try the modification below:

    <pre>Private Sub Worksheet_Activate()
    Application.EnableEvents = False
    Worksheets("SheetA").Visible = False
    Worksheets("SheetB").Visible = False
    Worksheets("SheetC").Visible = False
    Worksheets("ShowLetters").Visible = True
    Worksheets("HideLetters").Visible = False
    Application.EnableEvents = True
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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