Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
Activex controls in Excel 2003 | Excel Worksheet Functions | |||
Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
Tab between ActiveX controls on an Excel worksheet | Excel Programming | |||
Deleting worksheets containing ActiveX controls | Excel Programming |