A
Andy
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.
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.