Tabs
 

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

Tabs
 

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

Tabs
 

You can hide a tab just by selecting the sheet and then going under data and
selecting "hide" I don't know about the password...

"Johnnie" wrote:

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

Tabs
 

I'm sorry....I meant under window...and I guess it hides more than just one
tab though....so I guess I didn't help :-( sorry

"Johnnie" wrote:

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

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

Tabs
 

Johnnie,

Follow Ian's instructions to the letter. It will accomplish what you ask.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Johnnie" wrote in message
...
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

Tabs
 

Select the sheet to hide.

FormatSheetHide.

Now ToolsProtectionProtect Workbook with a password..


Gord Dibben MS Excel MVP


On Thu, 28 Feb 2008 12:14:02 -0800, Johnnie wrote:

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

Tabs
 

Hi Johnnie

Your latest missive refers to locking workSHEETs, my instructions refer to
locking the workBOOK.

If what you're asking is to be able to have the tab visible, but to either
do nothing or prompt for a password when it is selected, then I'm not sure
if it is possible. There may be a way in code to unhide the tab if the
workbook is unprotected and keep it hidden if it is protected, but I don't
know of a way.

Ian

"Johnnie" wrote in message
...
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