I have Excel 2010,XP SP3. My file has a lot of macros,so i saved it as test.xlsm I tryed to open my file on other pc with excel 2010 and it worked fine,but when i opened this file at excel 2007 at the first all was good,but when i run a macro it failed.The
reason: I lost all my groups(In my real file i do have on each sheet like 4-5 groups(each group has like 4-5 textboxes(ActiveXControls))).
So whats the reason for loosing groups in excel 2007?(Without them my vba fail)
i saved my file as 97-2003 woorkbook(test.xls) and it works good on excel 2007,but the file size increased from 1.8 MB to 4.5MB
question is how can i use .xlsm file made in 2010 on excel 2007