Excel 2000 ActiveX Control Problem
 

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.

Excel 2000 ActiveX Control Problem
 

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.