Hide Worksheet Page

V

Vercingetorix.XIII

Can I hide a worksheet page so it is not viewed by others but is still able
to provide data to other worksheets? If so, How and how would I unhide it
when I need to view it?

Thank you,
V.XIII
 
P

Pete_UK

With the sheet selected, click on Format | Sheet then click Hide. If
you want to unhide it, click Format | Sheet | Unhide and you will be
presented with a list of hidden sheets - just select the one you want.

Hope this helps.

Pete
 
J

JMay

If you have users who might have the boldness.knowhow to unhide the sheet by
doing the Format, Sheet, Unhide,,, You should know that you can using VBA
hide the sheet via it's visible property assigning it as:

Sheets("Sheet2").visible = xlSheetVeryHidden ' to hide

or

Sheets("Sheet2").visible = xlSheetVisible ' to unhide

Jim may
 

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

Hide Column 2
exclude amount from sumif total based on how many months 1
hide, unhide column or row after protect worksheet 4
Data Validation List Macro 18
copy formula 1
Hide row before printing 3
Hide Sheets 2
Permanently hide a worksheet in Excel 3

Top