Opening XLSM files created in Excel 2013 with Excel 2007

Folks,
I have googled this but apparently I am missing something. So I created an xlsm file in Excel 2013 and it has macros, drop downs and VBA code involved.
When folks try to open the file in Excel 2007 it seems that the code etc.... is not working. When they click a button, which is just copying some cell information and they try to paste it into notepad, there is nothing to paste, it is like the code is not triggering.

We tried to make sure in their trust center that macros were enabled etc... but still not working. Is there a detailed guide out there on how to test this and how to get it to work. I have alot of junior engineers that will need to use this File but they only have excel 2007.

THANKS SO MUCH IN ADVANCE.
Wally

Hi wfsteadman,

My speculation is that you are using a feature of Excel 2013 that is not available in Excel 2007. This may be associated with your 'Drop Downs' and 'Buttons' (and possibly other controls) which are probably 'Active X' controls. 'Active X' does not play well with others especially when migrating to previous versions of Excel.

I try to avoid 'Active X' in favor of:
a. UserForms
b. Forms Controls
c. Shapes

Try replacing one 'When they click a button' control with a 'Forms Control' or 'Shape' which will probably work.

If you need additional help please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Lewis