Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unProtect some cells on the spreadsheet
I have foloing code to let user enter data only in range
dim wsDestination as string wsDestination = "Mysheet" Sheets(wsDestination).Select ActiveSheet.Protection.AllowEditRanges(1).Delete ActiveSheet.Protection.AllowEditRanges.Add Title:=wsDestination & " Range " _ & "G12" , Range:=Range("G12:R36" ) ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True I have the code in the loop to unprotect cells in the spreadsheets. It seems that the code only unprotect the first in the loop or unprotect nothing. What I did wrong here? Any information is great appreciated, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unprotect a spreadsheet? | Excel Worksheet Functions | |||
Cells locking after Protect/Unprotect | Excel Discussion (Misc queries) | |||
how do I unprotect an excel spreadsheet in beta 2007 | Excel Discussion (Misc queries) | |||
unprotect control button only in spreadsheet | Excel Worksheet Functions | |||
How do I unprotect certain cells in a protected sheet? | Excel Worksheet Functions |