Disallow cell entries

[hopeace]

Can I block a cell from receiving any typed in info?

And can I lock formulas from being changed?

Thanks for you help!

[pinmaster]

Hi

You can Protect your sheet by going to TOOLS/PROTECTION/PROTECT SHEET, if there are cells where info will be entered then unlock those cells only by going to FORMAT/CELLS/Protection tab and unchecking the "Lock" option.

Hope this helps!
JG

[hopeace]

Thanks JG! I love this community forum!

JG: joyous giver
JG: jaunty geek (meant as compliment)
JG: jubilent graphmaker

!

[pinmaster]

Hi,
Yeah it sure is, I learned a ton of stuff in here. Thanks for the feedback!

Regards
JG

JG: Jean-Guy
lol