Hide Worksheet

J

James

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

Jacob Skaria

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
 
J

James

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Loop to hide sheet based on cell 1
Hide/Show some worksheets 2
hide colum based on cell value on each worksheets 2
Hiding worksheet 6
To protect user's privacy 1
Hide worksheet tab 1

Top