Macro for hiding a sheet

[karteekp]

Hey,

I need a code in VBA.
So, when I navigate between two sheets in excel, the need the latter one to be hidden and not displayed
Can anyone help?

 

[My Aswer Is This]

So if you only have two sheets and you navigate from sheet(1) to Sheet(2) and Sheet(1) is then hidden how do you plan to ever get back to Sheet(1)

 

[karteekp]

So I don't really need to display Sheet 1

 

[Jerome_RA]

Hey,

I need a code in VBA.
So, when I navigate between two sheets in excel, the need the latter one to be hidden and not displayed
Can anyone help?

Sheets("Sheet1").Select
Sheets("Sheet1").Visible = False
Sheets("Sheet2").Select
Sheets("Sheet2").Visible = True

And Vice versa