Hi,

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

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

Columns("P: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

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

dan dungan wrote:
>
> Hi,
>
> Running Excel 2000 and Windows XP, I'm using this macro to print a
> worksheet.
>
> Sub Hide_Print()
> Sheets("Print").Select
>
> Columns("P: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