Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlocking problem
Hi
I have columns that are normally locked with protection on. But, I need to have code that allows me to temporarily unluck column N. Why do I get an error (1004: unable to set the locked property of the range class) with this code? Activesheet.Columns("N:N").Select Selection.Locked = False thanks dorre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlocking problem
I assume the sheet is protected, so you need to unprotect it to change the
locked property Activesheet.Unprotect ActiveSehet.Columns("N:N").Locked = False Activesheet.Protect If you are just trying to work with the cells using code, you might use the interfaceonly property - only setable via code. Activesheet.Protect UserInterfaceOnly:=True This should avoid the need to unlock the cells. If you want to allow user access, then see the first suggestion. -- Regards, Tom Ogilvy "dorre" wrote in message ... Hi I have columns that are normally locked with protection on. But, I need to have code that allows me to temporarily unluck column N. Why do I get an error (1004: unable to set the locked property of the range class) with this code? Activesheet.Columns("N:N").Select Selection.Locked = False thanks dorre |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
unlocking problem
try unlocking the worksheet first then relocking it
-- When you lose your mind, you free your life. Ever Notice how we use '' for comments in our posts even if they aren''t expected to go into the code? "dorre" wrote: Hi I have columns that are normally locked with protection on. But, I need to have code that allows me to temporarily unluck column N. Why do I get an error (1004: unable to set the locked property of the range class) with this code? Activesheet.Columns("N:N").Select Selection.Locked = False thanks dorre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unlocking right margin | Excel Discussion (Misc queries) | |||
unlocking a row | Excel Discussion (Misc queries) | |||
Unlocking cells | Excel Discussion (Misc queries) | |||
Unlocking in 97 | Excel Programming | |||
Unlocking Cells | Excel Programming |