View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Larryq22 Larryq22 is offline
external usenet poster
 
Posts: 13
Default how do i hide a single worksheet in a workbook?

In Excel 2007, you can highlight the sheet/right-click/choose "hide." To
unhide it, highlight the sheets before and after it, right-click, choose
"unhide." Just like hiding/unhiding worksheet rows or columns.

Larry



" wrote:

On Nov 12, 2:03 pm, "Bob Phillips" wrote:
Just goto FormatSheetHide with the appropriate sheet active.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

ps.com...



How do i hide a whole worksheet?


i've tried to click on that particular worksheet in a workbook and
hide just it, however it hides the whole workbook. i have a workbook
where people need to see the first 2 worksheets. However the 3rd
worksheet is a database of information that is connected to the first
2 worksheets so it needs to (and i would like it to) stay with the
whole workbook but just hidden so no one messes with it.


is this posisble?- Hide quoted text -


- Show quoted text -


thanks a bunch