I've designed a spreadsheet in excel 2010 that has a dropdown list and a macro attached to a button. These work fine in office 2010 but when another user opens the file using excel 2007, the macro encounters an error and the dropdown arrow has disappeared.
Any suggestions what I can do to resolve this?
I've tried changing the macro setting in excel but this didn't work.
Not sure if this is the correct forum but seeing as a macro was involved I thought I'd try here first!