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.