Application crashed on print
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 |
Application crashed on print
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 |
All times are GMT +1. The time now is 06:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com