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

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


"Jay" <(E-Mail Removed)> wrote in message
news:8be179cd-63a2-4322-af04-(E-Mail Removed)...
> 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
>
>

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...

"Jay" wrote:

> 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
>
>
> .
>

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

On Tue, 5 Jan 2010 14:31:17 -0800 (PST), Jay <(E-Mail Removed)> wrote:

>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
>