LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Bug in Excel 2003 involving ActiveX Controls on worksheets

I have discovered that there is a bug in Excel 2003 (and Excel 2002), which I
think has propagated since Excel 97. I have found references to this bug for
Excel 97 (with workarounds identified), but the bug still exists and worse,
the workarounds identified for Excel 97 do not work. Here is what I have
discovered:

Place an ActiveX button on a worksheet with vba click code supporting it.
Activate the control (press the button).
Save the workbook before activating any other worksheet (or workbook) and
before manually selecting any cell on the worksheet.
With vba code in the Workbook_Open subroutine that either selects or
activates the worksheet that contains the ActiveX button, re-open the
workbook.

Excel crashes with a 32809 run-time error at the line that selects or
activates the worksheet (or any range on the worksheet) with the ActiveX
button. Less frequently, it may crash with a 57121 run-time error at the
same point.

Excel 2003 seems to corrupt the vba code somehow, because Excel 2003 does
not recover from this error (even by resetting vba execution) until the
workbook is closed, opened with macros disabled, saved, and then re-opened.
The workarounds identified for Excel 97 of setting the "TakeFocusOnClick" for
the ActiveX button to false does not help in Excel 2003.

The error does not show up if any manual selection is made prior to closing
the workbook after pressing the ActiveX button.

Does anyone have knowledge of this problem or comments?
 
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
No ActiveX controls when reading 2007 file formats into Excel 2003 Tony Excel Discussion (Misc queries) 0 May 30th 07 07:16 PM
Activex controls in Excel 2003 Tom Stewart Excel Worksheet Functions 2 April 9th 07 04:46 PM
Help with Excel ActiveX listbox controls programmer123 Excel Discussion (Misc queries) 0 July 7th 05 10:30 PM
Tab between ActiveX controls on an Excel worksheet Bill[_27_] Excel Programming 3 September 9th 04 01:15 PM
Deleting worksheets containing ActiveX controls Alex[_24_] Excel Programming 4 May 10th 04 08:51 AM


All times are GMT +1. The time now is 10:03 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"