Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() Karin - try this if I understand your dilema. I dont know what Excel you are using but in general try this: 1) tools/protection/unprotect sheet 2)select all the cells in your sheet and then format/cells/protection - uncheck "locked" and when box is unchecked click OK. 3) select your destination cells that you want to protect and then format/cells/protection - then check "locked" then OK. 4) tools/protection/protect sheet I don't believe that the user can modify the destination cells now. Good luck Jim Bray -- JimBray ------------------------------------------------------------------------ JimBray's Profile: http://www.excelforum.com/member.php...o&userid=24554 View this thread: http://www.excelforum.com/showthread...hreadid=381327 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
How may I remove Office 2003 DRM protection from DOC & XLS files? | Excel Discussion (Misc queries) |