ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pagebreaks (https://www.excelbanter.com/excel-programming/291882-pagebreaks.html)

Yiannis H. Economides

pagebreaks
 
Is there a way to disable (with VBA) the page breaks
and use only code inserted page breaks ?

Yiannis H. Economides

Tom Ogilvy

pagebreaks
 
Automatic pagebreaks only come into play if they are required. If you put
in a pagebreak a line 100 and line 200, but the sheet can only print 66
lines per page, then the automatic pagebreak is created. If you put in
pagebreaks at 60, 120, 180, 240, then the automatic pagebreaks will not
appear.

--
Regards,
Tom Ogilvy

"Yiannis H. Economides" wrote in message
...
Is there a way to disable (with VBA) the page breaks
and use only code inserted page breaks ?

Yiannis H. Economides





All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com