Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Control of Sheets (XL97; SR2)

    Is it possible to control the visiblity of a sheet once you leave it?

    As an example- If you are in Sheet2 and you click on the tab for Sheet1, Sheet2 is then made invisible.

    Thanks,
    John

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

    Re: Control of Sheets (XL97; SR2)

    You could put this code in the Deactivate event routine for Sheet2:

    <pre>Private Sub Worksheet_Deactivate()
    Worksheets("Sheet2").Visible = False
    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
  •