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

M

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
 
D

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
[email protected]
 
M

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.
 
Top