Application crashed on print

[dan dungan]

Hi,

Running Excel 2000 and Windows XP, I'm using this macro to print a
worksheet.

Sub Hide_Print()
Sheets("Print").Select

Columns("P").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="<>0",
Operator:=xlAnd
ActiveSheet.PrintOut
Selection.AutoFilter
Sheets("QuotedPart").Select
Range("A2:C2").Select
End Sub

It's been working fine for several months.

I have a worksheet, Formulas, where i store pricing instructions and
pull these with a vlookup when the agent selects a part number from a
dropdown box on another worksheet, QuotedPart.

The manager wanted me to add bullet points to sentences in a cell.

Excel crashed while I was adding the bullet points and returned the
message, "Excel has generated errors and needs to close. An error log
has been created."

Also, Excel started crashing when I clicked the command button I
created to print the worksheet.

I removed the bullet points and deleted temp files and I seemed to be
back in business.

Two other agents use this workbook which I saved on the network drive
as a template with an .xlt extension.

Yesterday agent A wasn't able to print. We changed her default
printer, and she was able to print. The same thing happened today.

Agent B experienced no printing failure until about 3:30 today.

When I step the code, the workbook doesn't freeze or crash, and
printing is successful. So I don't see anything that indicates the
reason for crashing/ and or freezing up.

Are there any recommendations to stop the crashing and freezing?

Thanks,

Dan

 

[Dave Peterson]

Just a guess...

When these kinds of things happen (to stuff that looks like it should
work--well, to me anyway), I guess that it's the printer that's causing the
trouble.

I'd get a newer/fresh version of the printer driver to see if that helps.

(And it sounds like Agent A's experience points at the same thing.)