Long Pause in printing spread sheet

[williekay]

I have a spreadsheet I've used for years. It has a ton of VBA code behind button clicks. It references a lot of books both inside the document in other worksheets and in another spreadsheet. It has a form that prints with a page break. I have a button for saving the record and printing the document. It used to print well now it takes three minutes before it prints using either the Microsoft Toolbar button or my VBA button???????

Willie

 

[SkipVought]

Hi,

Is this printing to a network printer? If os, has anything changed with respect to the network?

Has the workbook significantly changed with respect to size? This may not be a VBA-related issue, so you might want to also post in Forum68.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]

 

[williekay]

Thanx Skip- all of that is true- we're networked, records are added daily so it get's larger each day, but I solved my own problem. I got on a MS site before I started this and found a write up on pauses while scrolling and one solution was to unset the page breaks. I played around and found that if you set the document to PAGE BREAK VIEW it prints normal. I rewired my buttons to open PAGE BREAK VIEW, print, then return to normal.

Thanx Again though.

Willie

 

[SkipVought]

Thanks for sharing what you learned. I'm sure that it will help other Tek-Tip members.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]