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.