Results 1 to 5 of 5

Selecting a sheet from a range - issue with hidden sheets.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Selecting a sheet from a range - issue with hidden sheets.

    Hi,

    I have the below code that selects the sheet from a dropdown list box as selected by the user. How can I modify it so that it unhides hidden sheets first - as at present im just getting an error if the selected sheet is hidden.


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$E$10" Then
    Sheets(Range("E10").Value).Select
    End If
    End Sub
    Last edited by Barking_Mad; 05-09-2013 at 10:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1