View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Protect - Certain Rows / Columns

Range("A:E").Cells.Locked = True
Range("F:IV").Cells.Locked = False
Activesheet.Protect Password:="ABC"

--
Regards,
Tom Ogilvy


"RigasMinho" wrote:

In excel you can protect the whole worksheet to be protected.

Is there a way to protect only certain rows / columns?

I dont want to do the cell protection because that would take too long.

What would be nice is to protect columns a-e and let the users do what
they want for the rest of the sheet.