Thread: macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default macro

Cells are locked or unlocked - but to change that setting you have to
unprotect the worksheet

Activesheet.Unprotect Password:="ABC"
cells.Locked = True
Range("A6:O6").Locked = False
Activesheet.Protect Password:="ABC"

--
Regards,
Tom Ogilvy


"holy41" wrote:

I need a macro command to unprotect cells A6:O6. I don't won't to unprotect
the whole Sheet could someone help me ?

Thank Ken