Thread: Tabs
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Johnnie[_2_] Johnnie[_2_] is offline
external usenet poster
 
Posts: 29
Default Tabs

Ian,
Thanks for the info. However, although I can protect the worksheet so no
modifications can be made, I would like to lock it so it can not be viewed at
all without a password. Example: I have ten worksheets in a workbook
(1-10). Can I lock worksheet #2 so that only I or someone with the password
can view it. I failed to let you know I have Office 2003. Thanks.
Johnnie

"Ian" wrote:

I assume you mean you want to hide a worksheet within a workbook.
Hide the sheet, then protect the workbook with a password.
ToolsProtectionProtect Workbook

Ian

"Johnnie" wrote in message
...
Is is possible to hide/lock a tab in a spreadsheet so it can not be
opened/viewed without a password?
Thanks for your help.
Johnnie