Try recording a macro when you:

Unprotect the worksheet
select your range
format|cells|protection tab (lock those cells)
reprotect the worksheet.

It should be pretty close.

call_Vishwa wrote:

How would I lock and unlock cells (protect) programmatically. Say I have a
Range myRange - How would I Protect those for editing?

Thanks in advance for your help

Call_Vishwa

--

Dave Peterson