LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activate method of Worksheet class fails in Excel 2000 Chris Bloom Excel Discussion (Misc queries) 3 September 10th 05 12:05 AM
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Problem with Excel 2000 ACN Bug Excel Discussion (Misc queries) 2 July 29th 05 10:23 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"