View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
NBVC[_79_] NBVC[_79_] is offline
external usenet poster
 
Posts: 1
Default Locking everything except cells B4:B8


Select the range you want to unlock and go to Format|Cells and in the
Protection tab uncheck the "Locked" checkbox.. click Ok.

Now re-protect the sheet through Tools|Protection|Protect Sheet.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113004