Protect - Certain Rows / Columns
 

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.

Protect - Certain Rows / Columns
 

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.

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.

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.