View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Protecting Cells

Range("a1:a23,B4:B7,L2").Locked = False

Must be done when the worksheet is unprotected

or do it manually.

--
Regards,
Tom Ogilvy

"teresa" wrote in message
...
Hi - how do I protect a worksheet
but allow users to edit a range of cells:

a1:a23, b4:b7,l2

Thank You