Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page Breaks
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 |
#2
|
|||
|
|||
Page Breaks
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page breaks | Excel Discussion (Misc queries) | |||
How can I do one-time printing without set page breaks? | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |