Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect a sheet so the rows/columns can't be deleted? | Excel Worksheet Functions | |||
Protect Hidden Columns and Rows | Excel Discussion (Misc queries) | |||
Protect hidden rows/columns -macro help | Excel Discussion (Misc queries) | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
Protect Rows depending on Values in Particular Columns | Excel Programming |