Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am creating a sales quote template in excell 2003. I would like to have my
quote on 1 sheet and my costing on a second with some of the fields being linked from sheet to sheet . Is it possible to hide the tab for the costing sheet and then password protect it so that my customers can't open it? Is there a better |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You should do it the other way around.
Protect your sheet with: Tools -- Protection -- Protect Sheet (don't forget the password) then goto Format -- Sheets -- Hide The User can of course unhide again. If you want to hide it completely from Excel you have to open the VB- Editor (Alt+F11) select the sheet-module in the project-explorer (ctrl + r), open properties (F4) and select Visible: 2 - XlSheetVeryHidden. that way Format -- Sheets -- unhide doesn't work. and to protect it completely, in the VB-Editor goto Tools -- VBA Project Properties -- Protection and enter a password. hth Carlo On Dec 19, 3:24 pm, slowboat wrote: I am creating a sales quote template in excell 2003. I would like to have my quote on 1 sheet and my costing on a second with some of the fields being linked from sheet to sheet . Is it possible to hide the tab for the costing sheet and then password protect it so that my customers can't open it? Is there a better |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock all menu tabs | Excel Discussion (Misc queries) | |||
How do i lock tabs so that only an admin can edit them? | Excel Discussion (Misc queries) | |||
hide the tabs | Excel Discussion (Misc queries) | |||
create view tabs | Excel Worksheet Functions | |||
Tree View of spreadsheet tabs: is it possible? | New Users to Excel |