drop-down menu disappeared when saving in Excel 2010 and opening in Excel 97-2003

Hi,

I just solved a quite annoying problem and wanted to contribute.

I have a file that has a lot of dropdown lists. I had to program some event handling macros for my colleagues. They could open the file in Excel 2007 (I worked in 2010), even the macros ran perfectly, however the drop-down menus that were set by "data validation lists" couldn't appear somehow. When you right-clicked the cells, some values were in the lists and you could choose some of them but in general, the lists were wrong as well. So I came up with a solution. Program a macro that sets the drop-downs when the file opens. This way, it doesn't matter if they disappear between saving and reopening, they will get in the right place when opening the file.

I hope I could help some of you Have a nice day!


Code below: (mine looked a bit more complicated but this is way in general. if you want to use it for more ranges, you can copy&paste it several times or use some cycles.)

Please Login or Register  to view this content.