CommandButton works in v.2007 but is unclickable in v.2003

[Jay]

Hi all,

I have this silly little backwards compability problem. The button and
the macro that is connected to it works just fine in 2007. However,
when I save my file as an macro-enabled file and open it 2003. The
button is uncklickable, and it just selects it. DESIGN MODE is OFF,
macros are enabled and it is not the security level that is the
problem. What could it be?


BR,
J

 

[Harald Staff]

Hi

Macro enabled file? That's 2007 format xlsm and some converter in the
receiving end? Try saving as 97-2003 workbook xls.

HTH. Best wishes Harald

 

[ker_01]

I ran into this a while back. I apologize for not recalling the technical
details, but you are correct that the default sheet controls are not backward
compatible to XL2003.

In the end, my solution was to build in 2003, because it is easier to be
forward compatible...

 

[Gord Dibben]

When you open the *.xlsm in 2003 do you get the "file conversion in
progress"?

I also get a message about uninitiialized activex controls being disabled.

Do you receive that? I have no clue how to get rid of it.

Forms buttons are OK.


Gord Dibben MS Excel MVP