Hiding worksheet

  • Thread starter Thread starter Link
  • Start date Start date
Hi,

To hide it use

Sheets("Sheet1").Visible = False

or to prevent someone simply unhiding it use

Sheets("Sheet1").Visible = xlVeryHidden

Mike
 
Do you click on the sheet tab?

Mike H said:
Hi,

To hide it use

Sheets("Sheet1").Visible = False

or to prevent someone simply unhiding it use

Sheets("Sheet1").Visible = xlVeryHidden

Mike
Click to expand...
 
Hi,

It can go as worksheet code. Right click your sheet tab, view code and paste
this in and run it

Sub HideMe()
Sheets("Sheet1").Visible = xlVeryHidden

End Sub

Mike
 
after using xlVeryHidden, how would I unhide the sheet in my workbook?
 
You must log in or register to reply here.

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
Loop to hide sheet based on cell 1
hide colum based on cell value on each worksheets 2
Hide Worksheet 2
To protect user's privacy 1
detecting a proteced workbook 4
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Storing and Accessing Data 1

Back
Top