How to create a Macro to open and/or hide worksheets

[Charles_]

Hello,

I have tried searching for this on other threads to no avail.

I am trying to create a Macros where depending on the value of cell A2 (I have a data validation LIST type here), worksheet 1 or worksheet 2 will open.

For example, if the value on worksheet 1 cell A2 = "Yes" then hide worksheet 1 and 3 and open worksheet 2 only

if the value on worksheet 1 cell A2 = "No" then hide worksheet 1 and 2 and open worksheet 3 only.


I do not need to copy and paste any data across - worksheets 1 & 2 are completed

Thanks in advance.

 

[Charles_]

Hello,

I have found a solution for this issue by creating a button and defining the below

Private Sub CommandButton1_Click()


Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.Visible = False


End Sub

Thanks