Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell validation on protected sheets
I am trying to update cell data validation lists on a protected sheet. Using
protect/unprotect every time is cumbersome and difficult. So I am using userinterfaceonly:=true so that the code can update protected sheets. But this doesn't seem to allow it to update cell validation lists - I get the familiar application-defined or object-defined error messsage. Suggestions welcome. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell validation on protected sheets
There are somethings that can't be done by code even when you use the
UserInterfaceOnly parm. You have to unprotect, do the work, and reprotect in those cases. And you have one of those cases. timp wrote: I am trying to update cell data validation lists on a protected sheet. Using protect/unprotect every time is cumbersome and difficult. So I am using userinterfaceonly:=true so that the code can update protected sheets. But this doesn't seem to allow it to update cell validation lists - I get the familiar application-defined or object-defined error messsage. Suggestions welcome. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell validation on protected sheets
Thank you Dave - meantime I simplified my protect/unprotect puzzle (turned
off events so that my event change sub wasn't calling itself repeatedly and trying to make changes after it had finished once and turned protection back on). Haven't completely cracked it yet but am hopeful. "Dave Peterson" wrote: There are somethings that can't be done by code even when you use the UserInterfaceOnly parm. You have to unprotect, do the work, and reprotect in those cases. And you have one of those cases. timp wrote: I am trying to update cell data validation lists on a protected sheet. Using protect/unprotect every time is cumbersome and difficult. So I am using userinterfaceonly:=true so that the code can update protected sheets. But this doesn't seem to allow it to update cell validation lists - I get the familiar application-defined or object-defined error messsage. Suggestions welcome. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Allow selection of Validation List in a Protected Cell | Excel Discussion (Misc queries) | |||
1004 Cell Protected Error for data validation lists when locked and protected | Excel Programming | |||
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
validation lists and protected work sheets | Excel Programming |