Excel 2000 ActiveX Control Problem

[Guest]

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.

 

[Bernard Liengme]

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