Hi,

I'm listing through sheets and have Sheet2 for drop-down lists.

Sheet2 is not visible, but when I click on Cmdbutton It appears so that I can change values in drop-downs. When I hide Sheet2 again, I want to be back on sheet before Sheet2.

My code for open and close sheet2 :

Sub open_sheet()

Worksheets("Sheet2").Activate
Worksheets("Sheet2").Visible = True

End Sub

Sub close_sheet()

Worksheets("Sheet2").Visible = False
End Sub
How can I do that ?