Try right clicking the button and look in View Code
This is where you tell the button what to do when it is clicked

OR, better yet, for simply running a macro stay with Form buttons

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andy" wrote in message
...
I'm having the stupidest problem with Excel 2000 and it's making me crazy.

Every fresh install I do of Office 2000 results in Excel being unable to
properly use ActiveX controls. If someone creates a spreadsheet with
macros/VBA in it, and use an ActiveX control to make a button to call the
macro, it won't work. Clicking on it does nothing. Likewise with
checkboxes
and other ActiveX controls. However, if someone makes a button from the
Forms
toolbar, it launches the macro correctly.

I'm thinking that something is missing from the installation, but I have
no
idea what. I've done a full install of Office 2000 (everything down to
Frontpage fully installed on the local computer just to catch everything),
applied SR1, SP2 and SP3, and a few of the post-SP3 patches and I can't
figure it out. Unless Excel is somehow stuck in Design Mode when it says
it
isn't.

Unfortunately, I have no control over the macros/spreadsheets being
created
so I can't just say "use the Forms toolbar to create buttons". Any help
would be much appreciated.