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.