VBA - Delete Drop Down, Retain Values
 

Group,
Is it possible through VBA to delete a sheets drop-down lists, yet
retain the value selected in the list? I think this is a toughy. Help
for fledgling, wanna be VBA programmer would cap this weekend.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=391601

VBA - Delete Drop Down, Retain Values
 

Hi Tony:

Try:

ActiveSheet.UsedRange.Validation.Delete


---
Regards,
Norman



"ajocius" wrote in
message ...

Group,
Is it possible through VBA to delete a sheets drop-down lists, yet
retain the value selected in the list? I think this is a toughy. Help
for fledgling, wanna be VBA programmer would cap this weekend.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile:
http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=391601