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

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

Hi Kennbu

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

--
Regards Ron De Bruin
http://www.rondebruin.nl



"Kennbu" <[email protected]> wrote in message news:[email protected]...
> In Excel 2000, can I automatically set page breaks to every 40 lines instead
> of the default 52 lines?