Disallow cell entries
 

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

And can I lock formulas from being changed?

Thanks for you help!


--
hopeace
------------------------------------------------------------------------
hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009
View this thread: http://www.excelforum.com/showthread...hreadid=476057

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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476057

Thanks JG! I love this community forum!

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

!


--
hopeace
------------------------------------------------------------------------
hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009
View this thread: http://www.excelforum.com/showthread...hreadid=476057

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

Regards
JG

JG: Jean-Guy
lol


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476057