View Single Post
  #2   Report Post  
JimBray
 
Posts: n/a
Default


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