Hiding Formula

  • Thread starter Thread starter James Johnson
  • Start date Start date
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!!!!
 
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
 
Back
Top