Tabs

J

Johnnie

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
 
I

Ian

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

Ian
 
J

jlojones821

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...
 
J

jlojones821

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
 
J

Johnnie

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
 
E

Earl Kiosterud

Johnnie,

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

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
 
G

Gord Dibben

Select the sheet to hide.

Format>Sheet>Hide.

Now Tools>Protection>Protect Workbook with a password..


Gord Dibben MS Excel MVP
 
I

Ian

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
 
Top