Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data bar conditional formatting based on another cell | New Users to Excel | |||
Formatting Data in cell in colour | Excel Discussion (Misc queries) | |||
Copy data to new cell but with different formatting | Excel Discussion (Misc queries) | |||
Cell formatting when importing data | Excel Discussion (Misc queries) | |||
Cutting Data from cells changes Cell Formatting | Excel Programming |