How do I protect only formulas(functions) in a workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating an audit sheet for a hotel and need to have formulas that
employees can not change. But they need to be able to plug in numbers into
the cells where the formulas are.
 
format the cells to be locked with the exception of the cells that you want
to be able to input data, then protect the worksheet
 
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

Daily Time Sheets with Rounding 1
IF AND Nested Functions - Formula Not Working 0
Building closed workbook file path within an Index Function 6
Protecting is NOT working right !!!!!!!!!!!!!! 6
Excel Drag autofill only part of formula 3
Vlookup formula 2
Excel Protection 2
How do I put a formula into an unlocked cell on protected workshee 1

Back
Top