This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!