protection

  • Thread starter Thread starter John
  • Start date Start date
J

John

How do you protect all the sheets in a workbook so the user can't enter
something in a cell that has a formula?

Thanks

JOhn
 
Hi John,

Excel security is quite weak, almost any non beginner can bust the password
for a worksheet in just a few minutes. If the co-workers "respect" the fact
the sheet is protected then it may help.

Otherwise don't put anything super secret under worksheet protection.

Tools > Protection > Protect worksheet > enter your password > OK out.

HTH
Regards,
Howard
 
By default cells are 'Locked' but are only protected when you protect the
worksheet as a whole.

If you want users to enter data into empty cells then 'Unlock' the cells
first then protect the sheet.
 
I want it so that you can not enter ANYTHING in a cell with a formula.
I've tried a bunch of locking/protecting things and can't get the sheet
to prevent entry in a cell with a formula.

If there is a way I'd appreciate a step by step explanation. Clearly I
don't understand the process. office 2003 excel

Thanks

John
 
Back
Top