Can someone tell me how I can get the page breaks to stay checked. Is there
a registry setting or group policy setting? I have searched but missed it
somewhere. I like them to be on all the time.
Thanks Bruce
Can someone tell me how I can get the page breaks to stay checked. Is there
a registry setting or group policy setting? I have searched but missed it
somewhere. I like them to be on all the time.
Thanks Bruce
Be careful what you ask for you may just get it.
Page breaks are turned on in Print Preview, or in
tools, Options, view, page breaks. They can slow down
Excel, particularly in macros.
Inserting rows is slow (#insert)
http://www.mvps.org/dmcritchie/excel...esp.htm#insert
In a macro to turn off use
ActiveSheet.DisplayPageBreaks = False
to turn on use
ActiveSheet.DisplayPageBreaks = True
You could turn them on in your Auto_Open macro.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Me2Ewe" <[email protected]> wrote in message news:[email protected]...
> Can someone tell me how I can get the page breaks to stay checked. Is there
> a registry setting or group policy setting? I have searched but missed it
> somewhere. I like them to be on all the time.
> Thanks Bruce
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks