Hi - how do I protect a worksheet
but allow users to edit a range of cells:

a1:a23, b4:b7,l2

Thank You

Hallo,

ActiveSheet.Cells.Locked = True
Range("A1:A23,B1,B1,B4:B7,B1,L2").Locked = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Greetings jonjo

"teresa" wrote:

Hi - how do I protect a worksheet
but allow users to edit a range of cells:

a1:a23, b4:b7,l2

Thank You

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