Viewing Worksheets based on selection list

Bobzter

New member
Joined
Jan 18, 2014
Messages
1
Reaction score
0
Points
0
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?
 

NoS

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
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
 
Top