Lock Formulas

K

kreiss

How do I look the formulas so users can enter data, but
can't change the formula?

Thanks,
Kacy
 
G

Gilles Desjardins

Hi Kacy,
First, remove the lock possibility from the cells you DO NOT want to lock:
Select those cells, Format, Cells, Protection and remove the check mark.
Second, Tools, Protect sheet, password. This shall prevent people from
changing your formulas but they will be able to input data in the
unprotected cells.

HTH

Gilles Desjardins
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Autonumber field in Excel that behaves the same as Access 0
Array formula lock-up 1
How to clear areas of a locked Doc after each use-- 0
Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Table of content - format does not get saved 2
Display weeks from a Milestone 0

Top