View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
carlo carlo is offline
external usenet poster
 
Posts: 367
Default hide tabs from view then lock tabs?

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