2007 macro and active X controls in 2003

**ajaykgarg** · 08-09-2010, 05:11 AM

Hi

I started my dev in excel 2003 and changed to 2007 in between.

Now, my active X controls and some commands (e.g. hiding / veryhiding a sheet) in macros refuse to work in 2003, though they work properly in 2007.

Is there a check-list that I can run through to make sure I have covered all bases for it to work in 2003?

tia
Ajay

**royUK** · 08-09-2010, 05:28 AM

Hiding sheets should be no different

**ajaykgarg** · 08-09-2010, 06:32 AM

I opened the .xlsm (2007) file with Excel 2007 and saved it as .xls (2003). Then, if I open this .xls file with 2003, everything works as expected.
God bless Google.

Thanks
Ajay