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" <Kennbu@discussions.microsoft.com> wrote in message news:DF70BCF4-7926-40FD-842C-5DBEAA10E1EB@microsoft.com...
> In Excel 2000, can I automatically set page breaks to every 40 lines instead
> of the default 52 lines?