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
    British Columbia
    Excel Version
    Excel 2010
    try something like this in your 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

Posting Permissions

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