Hi,

Am Thu, 15 Aug 2013 07:09:44 -0700 (PDT) schrieb Snowfi

I can create a list from an adjacent sheet no problem and it works...but when I save exit and restart the workbook the drop-down is not active. The drop down icon is on the cell but will not work. The settings are also gone when I re-enter the range again only to loose it when I exit and re-open... any ideas?

what Excel version do you use? In xl2007 or earlier you have to name the
list if it is not on the same sheet as the validation.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2