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 |
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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com