Hide Worksheet

  • Thread starter Thread starter James
  • Start date Start date
J

James

Is there a way I can hide a worksheet once I click off it, once I click on
any other worksheet. Thanks.
 
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
 
thanks, worked great

Jacob Skaria said:
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
Click to expand...
 
Back
Top