View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Sleeper Andy Sleeper is offline
external usenet poster
 
Posts: 1
Default InsertLines crashes Excel

I am writing code that adds a CheckBox to a worksheet with a Click event
handler in the worksheet code module.

The problem is that the InsertLines method crashes Excel with a "Automation
error Exception occurred" message.

This happens whether my virus scanner is enabled or disabled. It also
happens on a different machine with no virus scanner. It happens identically
in Excel 2002 and 2003. But oddly, it does not happen every time I use
..InsertLines. Sometimes it works fine.

Any ideas why Excel might be crashing?

Thanks,
Andy