| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change validation on protected sheet
I have a shared and protected sheet
Although the cells in question are unlocked VBA will not allow the validation to be changed. (Works fine if the sheet is unprotected but protection is necessary) Is there a way round this Thanks -- Patrick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| How to prevent Cut&Paste to change style and data validation on protected sheet | Excel Discussion (Misc queries) | |||
| How to prevent Cut&Paste to change style and data validation on protected sheet | Excel Discussion (Misc queries) | |||
| Apply Validation on a protected sheet | Excel Discussion (Misc queries) | |||
| change font when sheet is protected | Excel Discussion (Misc queries) | |||
Threaded Mode
