Range("a1:a23,B4:B7,L2").Locked = False
Must be done when the worksheet is unprotected
or do it manually.
--
Regards,
Tom Ogilvy
"teresa" <teresa@discussions.microsoft.com> wrote in message
news:67895543-8C1A-4ED3-BE16-BC59DB6EE96E@microsoft.com...
> Hi - how do I protect a worksheet
> but allow users to edit a range of cells:
>
> a1:a23, b4:b7,l2
>
> Thank You
Bookmarks