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).

That would be if you embedded excel in a word document or powerpoint slide
and then tried to automate that embedded instance. Doesn't sound like that
is what you are doing.

--
Regards,
Tom Ogilvy

"Don Wiss" wrote in message
...
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).