Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
Tabs at the top | Excel Discussion (Misc queries) | |||
Can i set up tabs within tabs on Excel? | Excel Worksheet Functions | |||
tabs | Excel Discussion (Misc queries) | |||
How to hid just one or two tabs | Excel Discussion (Misc queries) |