is there a way to hide a whole worksheet in excel?

[Marion McFarlane]

I would basically like to place all formulae on one worksheet and hide from
anyone tempted to amend. most folks know how to unhide cells etc. Even if
someone knows a sneakier way of making viewing of formula unviewable

[dominicb]

Good evening Marion McFarlane

To hide a worksheet go to Format > Sheet > Hide.

This can be unhidden through the same menu (but use unhide instead).

To hide cells from view press ctrl + 1 and change the number format to Custom and ;;; (three semicolons). The formulae will still show in the status bar, so to hide from there, press ctrl + 1 and in the Protection tab, make sure that Hidden is ticked. Then invoke worksheet protection (Tools > Protection > Protect Sheet).

If you want to go to extremes of hiding your sheets, use the xlVeryHidden flag to hide it (you really should be comfortable with the VBE to use this option - but if you're not I have a free add-in available that will allow you to control this flag without touching the VBE - just send me an e-mail).

HTH

DominicB
dominic@dom-and-lis.co.uk

[Mladen_Dj]

If you want to hide formulas, but left worksheet visible, select cells you
want to hide formulas, go to Format->Cells->Protection, check Hidden. Than
protect worksheet with password (go to Tools->Protection->Protect Sheet).
For hiding a whole worksheet (and if you don't want to be listed at dialog:
Format->Sheet->Unhide), go to VBE (Alt+F11) select sheet you want to hide,
and in Properties window (if its not visible press F4) select Visible->2 -
xlSheetVeryHidden.

"Marion McFarlane" <Marion McFarlane@discussions.microsoft.com> wrote in
message news:48BD0234-2257-42B5-8A1E-9B1B57360D0B@microsoft.com...
>I would basically like to place all formulae on one worksheet and hide from
> anyone tempted to amend. most folks know how to unhide cells etc. Even
> if
> someone knows a sneakier way of making viewing of formula unviewable