Can I set an automatic page breaks to break every 40 lines?

[Kennbu]

In Excel 2000, can I automatically set page breaks to every 40 lines instead
of the default 52 lines?

 

[Ron de Bruin]

Hi Kennbu

With code you can do this
http://www.rondebruin.nl/print.htm#Breaks