Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Data Validation from being overwritten
I have a workbook containing multiple sheets that rely heavily on
dropdown lists, generated by using named ranges in Excel's Data Validation as the list source. However, as most of you know, if a user performs a copy and paste operation into a cell with Data validation, the data validation is overwritten. I have code for Data Validation from John Walkenbach fine book "Excel 2002 Power Programming with VBA", but it does not provide protection for the list source and so doesn't meet my needs. Does anyone have any ideas. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Data keeps getting overwritten by macro | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |