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

"John" wrote in message
...
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

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.



--

Regards,
Nigel




"John" wrote in message
...
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

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

Nigel wrote:
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.