I have a scenario where a 2003 workbook disables certain controls within it's environments (thinks like the save, save as, page setup etc). This works perfect but the company I work for has decided to roll out Office 2010 over a period of time.

This isn't so much of a problem except for it is being done in phases. This is a problem as there will be a strong possibility that both 2003 and 2010 users will need to use the same spreadsheet at the same time.

I have written some code already that checks which version of office is installed and depending on the result, runs the required code (which worked great for sending emails) but the problem I have is with 2010 menu controls.

I cant install any 3rd party add-ons and all of the code I have found so far requires the workbook to be saved in a 2010 format which is not possible.

Is there a way I could write the code to disable 2010 controls from a 2003 workbook please? I have access to 2010 as Im currently piloting it if that makes life any easier?

Any solutions will get a virtual high five and muchos respect.

Kind regards,
Mav