Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem with Excel 2000 | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions |