| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Data Validation List from being modified in the formulabar
Hi all,
I have created a Data Validation List where the source is being taken from a separate worksheet. Once the worksheet is protected, the user will select something from the Data Validation List. I have noticed that the formula bar will display whatever the user selects and it is then possible for the user to modify this selection. Is is possible to protect the contents in the formula bar from being modified with VBA code? Thanks in advance? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Programming | |||
| Protecting cells with data validation | Excel Programming | |||
| Protecting Data Validation from being overwritten | Excel Programming | |||
Threaded Mode
