View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RigasMinho RigasMinho is offline
external usenet poster
 
Posts: 40
Default 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.