B
Brotherwarren
Hi folks,
Apologies if a solution is posted elsewhere:
I have a for .....next loop that contains a line to print a worksheet.
The worksheet that is printed contains around 30 textboxes, all taken
from the control toolbox.
The first 20 pages print without problem, but gradually the textboxes
fail to update in time for the next print.
I found a suggestion elsewhere to include a doevents command, but this
didn't work.
Another suggestion said to use a .refresh command, however I get an
object doesn't support this method error.
Here's the line: Worksheets("pupil flightpath").TextBox28.Refresh
Is there a problem with my syntax or is there another way to solve
this problem.
Many thanks for any and all advice!
\Tony
Apologies if a solution is posted elsewhere:
I have a for .....next loop that contains a line to print a worksheet.
The worksheet that is printed contains around 30 textboxes, all taken
from the control toolbox.
The first 20 pages print without problem, but gradually the textboxes
fail to update in time for the next print.
I found a suggestion elsewhere to include a doevents command, but this
didn't work.
Another suggestion said to use a .refresh command, however I get an
object doesn't support this method error.
Here's the line: Worksheets("pupil flightpath").TextBox28.Refresh
Is there a problem with my syntax or is there another way to solve
this problem.
Many thanks for any and all advice!
\Tony