Hide Worksheet
 

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

Hide Worksheet
 

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.

Hide Worksheet
 

thanks, worked great

"Jacob Skaria" wrote:

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.