Afternoon all,

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!

Thanks.