Protect - Certain Rows / Columns

[RigasMinho]

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.

 

[RigasMinho]

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.

Never mind - i figured it out.

i would have to select the cells first and lock the ones i want to be
protected.

then i would have to unlock the ones i dont want to be protected.

 

[Guest]

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