Protect - Certain Rows / Columns

R

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

RigasMinho

RigasMinho said:
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.
 
T

Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top