Hello group,

I am writing code which adds a CheckBox and an associated Click event
handler to a worksheet. The event handler code is about 250 lines long.
I've tested the event handler code, and it works.

The problem is that Excel crashes while executing the .InsertLines
method. Visual Basic says "Automation error Exception occurred." and
then Excel crashes and attempts to recover files.

Worse, this happens sometimes, but not all the time, when the exact
same subroutine is called to create the CheckBox_Click code.

I have searched posts and read that some virus scanners react to
InsertLines statements. I have Norton Internet Security Professional. I
disabled Norton and I still get errors. Then I ran the code on a
different computer with no virus scanner and a different version of
Excel (2002 instead of 2003). It also crashes in the same way.

Any ideas what I should be doing differently to get around this?

Thanks!
Andy


--
asleeper
------------------------------------------------------------------------
asleeper's Profile: http://www.excelforum.com/member.php...o&userid=26723
View this thread: http://www.excelforum.com/showthread...hreadid=399903