View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Understanding: "BUG: VB Hangs While Automating Excel Using OLE Control"

I have an application that for some users Excel freezes when they print.
Printing is done with a User Form that has lots of checkboxes and a few
buttons. If it does freeze, it tends to be on the same sheet. It appears
that this is the bug:

http://support.microsoft.com/kb/q181889/

Except in my case it is intermittent. And I'm not sure if my User Form is
an OLE control. One thing I could do, is to close the form before printing.
All I'd have to do is create a global variable with the checkbox values.
Does anyone have any insight on this?

Don <www.donwiss.com (e-mail link at home page bottom).