You can lock the cells. for which you need to:
Select all the cells, Format Cells Protection. Uncheck the locked
box. Then select the cells, which you want to lock, and again follow
the above steps and check the locked box this time. Then go to Tools
Protection, protect sheet. (Password is optional)
Another method, select the cell, go to data validation. Select say
decimal, and eual to some random number like 328454.2768 which you
don't expect the user to enter. In the error alert box, you can give
the message to the user saying edit so-and-so instead.
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=379229