Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the
right blank portion. Get back to to workbook and try out.

Private Sub Worksheet_Deactivate()
Me.Visible = xlSheetHidden
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"James" wrote:

Is there a way I can hide a worksheet once I click off it, once I click on
any other worksheet. Thanks.