I have a workbook that was (I think) originally created in 2003. I inherited
it as a workbook that had three worksheets, no macros, no activeX controls,
etc. To clean up data entry, I added a commandbutton (from the 'control
toolbox' toolbar) that opens a userform, and hid the rest of the sheets.
Since I use XL2003, I saved it as an XLS file.

I then sent it to my boss, who is on XL2007. He opened it, tested it, and
approved it. Since 70% of our widely dispersed department uses XL2007, I
asked him to save the file as an xlsm., then sent it back to me to post on a
sharepoint site for our team. Before doing so, I tried to open the file to
check something- and got the following error message:

"This file was created in a newer version of Microsoft Excel. The file has
been converted to a format you can work with, but the following issues were
encountered. The file has been opened in read-only mode to protect the
original file.

- Uninitialized ActiveX controls will not be opened in this version of Excel"

When I acknowledge the error, then enable macros, I can see my main
worksheet with the gray commandbutton, but clicking on it just selects it, as
if I were in design mode. I can toggle in and out of design mode, but the
button is dead.

(1) should I be using a different button to trigger my macro, i.e. is there
one that can withstand the conversion to XL2007 and still work when
downcoverted to XL2003?

Even if I upload a 2003 version, as soon as anyone with 2007 opens it,
enters their data, and saves it, I'll be back to having a document that won't
work for the next 2003 user.

Thank you,
Keith