macros enabled workbook compatability issues 2013 vs 2007

[narrowdave]

Hi - looking for help!!

I designed an 'macro enable excel workbook' based health assessment tool a few years ago. It worked fine on versions of Excel as far back as 2003.

I have just updated some of the content. A friend helped me with some coding to update a few features. He worked on it using excel365 and made some modifications that were beyond my expertise (nothing too fancy to be honest)... He emailed it back to me and all worked fine on my computer using Excel 2013...

Next I emailed it to a person (at the other end of the country) who wants to use it - he says it freezes and won't open in Excel 2007 - no error messages reported. He says he gets no security option to 'enable macros' - he's tried doing it through the Trust Centre and then opening the file, but it still freezes...

I don't know anybody else who still uses Excel 2007 and so am struggling to know how best to make sense of what's going on... Any ideas??

Thanks so much

Dave

 

[mole999]

presume it was xls if it worked in 2003, every new version of excel has new capability added.

your fre3ind should ensure anable macros is turned on in a blank work book first, then try loading the book, I don't think you can switch between on and off once open