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.
|