Hiding Worksheets & Formulas

[Dewayne Bien]

Is anyone aware of a way to certain hide worksheets in a
workbook and then hide the formulas within the worksheets
that remain visible?
Thanks for the help!

 

[Norman Harker]

Hi Dewayne!

For hiding worksheets:

Format > Worksheet > Hide

For hiding formulas:

Select all cells in a sheet [Ctrl+A or click button at intersection
of rows and columns]
Format > Cells > Protection
Place check in "Hidden"
OK
Tools > Protection > Protect Sheet
Give and confirm password [Optional]
OK

But note that by default, this will protect all cells. If you don't
want this then remove the check from "Locked" at the same time that
you place the check against Hidden.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.