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