Hiding Formula

J

James Johnson

I have a spreadsheet that has 3 pages one is titled "Estimate" one is
"Summary" and the third is a blank worksheet. For security reasons I
want to have all of the formula on the 3rd worksheet but have the input
and results appear on the "Estimate" sheet and the "Summary" sheet.
This way I can hide sheet 3. I do not want any formula on pages 1 & 2.
Can this be done without going to VB. Help!!!!
 
E

Earl Kiosterud

James,

You can use protection to hide the formulas. It's not necessary to have the
formulas in another sheet with this approach. Select cell(s), Format -
Cells - Protection - Hidden. You must unlock any cells into which user
change is allowed (Format - Cells - Protection - Unlock) You must also
protect the sheet for this stuff to take effect (Tools - Protection -
Protect sheet). Use a password when protecting the worksheet. And (excuse
me for shouting, but there is wailing and gnashing of teeth sometimes over
this one) DON'T LOSE THE PASSWORD! :)

If you put your formulas in another sheet, they can refer to the cells in
the original sheets (e.g.: =Estimate!B2 - Estimate! C2), and the original
sheet cells (where the formulas would have been) can refer to the formula
sheets (='Formula Sheet'!B2). But you need to protect this sheet from
prying eyes. You can hide the sheet but you'll need to prevent them from
unhiding it (Tools - Protection - Protect workbook (not worksheet)). Use a
password.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Top