I have created a spreadsheet in Excel07 with a few simple controls. In VB, I
created several buttons, most of which run a simple save / email command.
Some of my coworkers still run Excel 2003. When they open the spreadsheet,
the controls have no function at all.

I have saved the file in several different ways. it originated as a xlsm
(macro enabled excel file). When that wouldn't work on their 03 machines, I
saved the file as a 97-2003xls file. This allowed them to open the file, but
no buttons worked. On their machine, I edit security settings to allow all
macros, etc. This is causing a fatal error when the open the file.

So I'm stuck. How can I make my VB controls operate properly on a 2003
machine? Any help would be appreciated.

Are you talking about Ribbon Controls in 2007? If so, I don't believe you
can use them in 2003. There is other functionality you'll need to use and
I've never used it, so can't give you any more ideas.

Maybe someone else can.

Barb Reinhardt

"wdtanner" wrote:

> I have created a spreadsheet in Excel07 with a few simple controls. In VB, I
> created several buttons, most of which run a simple save / email command.
> Some of my coworkers still run Excel 2003. When they open the spreadsheet,
> the controls have no function at all.
>
> I have saved the file in several different ways. it originated as a xlsm
> (macro enabled excel file). When that wouldn't work on their 03 machines, I
> saved the file as a 97-2003xls file. This allowed them to open the file, but
> no buttons worked. On their machine, I edit security settings to allow all
> macros, etc. This is causing a fatal error when the open the file.
>
> So I'm stuck. How can I make my VB controls operate properly on a 2003
> machine? Any help would be appreciated.

Form controls on the worksheet itself. A button, coded in VB, that saves the
form then opens outlook, attaches the worksheet to an email, adds subject,
precipitants, etc.

"Barb Reinhardt" wrote:

> Are you talking about Ribbon Controls in 2007? If so, I don't believe you
> can use them in 2003. There is other functionality you'll need to use and
> I've never used it, so can't give you any more ideas.
>
> Maybe someone else can.
>
> Barb Reinhardt
>

When you open the workbook in 2003, do it with the SHIFT key down (or don't
enable the macros). Then compile the code to see what the issue might be.

"wdtanner" wrote:

> Form controls on the worksheet itself. A button, coded in VB, that saves the
> form then opens outlook, attaches the worksheet to an email, adds subject,
> precipitants, etc.
>
> "Barb Reinhardt" wrote:
>
> > Are you talking about Ribbon Controls in 2007? If so, I don't believe you
> > can use them in 2003. There is other functionality you'll need to use and
> > I've never used it, so can't give you any more ideas.
> >
> > Maybe someone else can.
> >
> > Barb Reinhardt
> >

A rule of thumb is that if your workbook will be opened by users of
various versions of Excel, you should create it in the oldest version on
which it will be opened.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



wdtanner wrote:
> I have created a spreadsheet in Excel07 with a few simple controls. In VB, I
> created several buttons, most of which run a simple save / email command.
> Some of my coworkers still run Excel 2003. When they open the spreadsheet,
> the controls have no function at all.
>
> I have saved the file in several different ways. it originated as a xlsm
> (macro enabled excel file). When that wouldn't work on their 03 machines, I
> saved the file as a 97-2003xls file. This allowed them to open the file, but
> no buttons worked. On their machine, I edit security settings to allow all
> macros, etc. This is causing a fatal error when the open the file.
>
> So I'm stuck. How can I make my VB controls operate properly on a 2003
> machine? Any help would be appreciated.