hide formula

N

Nico

Hi,

is there something I can do to hide my formulas from the end user in Excel?
My formulas are sometimes 3 lines long and cover the data in my sheets. This
workbook is located on a network, used over a few dozen computers so
disabling it in the Excel options is out of the question.

Regards,
Nico.
 
B

Barb Reinhardt

You could try to protect the sheet and allow users to enter only in fields
without a formula. You'd need to deselect the option of LOCKED on the
Protection tab of the Format cells option. In the cells with formulas, you
could select the HIDDEN option on the Protection tab.
 
N

Nico

Hi

Thanks. My sheet was already protected so nobody would change my formulas.
I'll change that protection so it can't be selected anymore.

Regards,
Nico.
 
Top