View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default cell lock does not work ?!

Ron will get back to you! <vbg

tools|Protection|allow users to edit ranges
(after you turn worksheet protection off)

huntermcg wrote:

Hello,

I have a worksheet wich I protect fully. Some cells are defined as
unlocked, wich aree available to enter date. Now I have some cells (not
all) wich, however they are protected/locked, still behave as a unlocked
cell. So, I can accidently still overwrite cells with formulas. I've
been looking throughout the forum but cannot find a solution .... does
anyone have an idea what this could be ? Or give me a hint where to
look ?

Regards,
Hunter

--
huntermcg
------------------------------------------------------------------------
huntermcg's Profile: http://www.excelforum.com/member.php...o&userid=19391
View this thread: http://www.excelforum.com/showthread...hreadid=510276


--

Dave Peterson