hide tabs from view then lock tabs?

[slowboat]

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

 

[carlo]

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