| 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. |
| 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 | |||
Threaded Mode
