Results 1 to 2 of 2

Thread: Viewing Worksheets based on selection list

  1. #1

    Viewing Worksheets based on selection list



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

    hi i have a workbook with 17 worksheets. of these 3 are always visible. on sheet one (Overview) i have a selector section from cells G15 - G28 which can select and of the 14 hidden worksheets in the order that i want to view them. i can unhide them easily using vba but they are viewed alphabetically and not in the order selected from the list g15-g28. anyone have the code that would allow the workbook to display the worksheets in the order they are selected, i.e. after the first 3 visible sheets?

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    try something like this in your code
    Code:
    'make it visible and move it to the end
        With Sheets(Target.Value)
            .Visible = True
            .Move after:=Sheets(17)
        End With
    'stay on sheet one
        Sheets("Sheet1").Activate

Posting Permissions

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