hide formula

  • Thread starter Thread starter Nico
  • Start date Start date
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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding formulas 4
checkbox problem 22
Excel 2013 vlookup to different workbooks not working 5
format slow down excel 3
Excel EXCEL - using a date dependant formula to hide rows 3
hide formulas 5
Copy formula 6
same formula and cells for different worksheets 1

Back
Top