| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page breaks
Hi Everyone
Is it possible to have the "Page Breaks" active all the time. If its by VBA, I would like it too be flexible for one workbook and all workbook if possible. Thanking you in advance. Regards John There is no failure except in no longer trying. Elbert Hubbard |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page breaks
Hi Again
Just rephrasing my question. Is it possible to show the page break on a worksheet without having to go everytime to ToolsOptions Page Breaks "John" wrote in message ... Hi Everyone Is it possible to have the "Page Breaks" active all the time. If its by VBA, I would like it too be flexible for one workbook and all workbook if possible. Thanking you in advance. Regards John There is no failure except in no longer trying. Elbert Hubbard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page breaks
You could have a macro do it.
John wrote: Hi Everyone Is it possible to have the "Page Breaks" active all the time. If its by VBA, I would like it too be flexible for one workbook and all workbook if possible. Thanking you in advance. Regards John There is no failure except in no longer trying. Elbert Hubbard |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page breaks
Thanks Bob
I guess its not possible by Registry or something ??, but you're right I could add a line to a macro like below. Sub Page break ActiveSheet.DisplayAutomaticPageBreaks = True End Sub Best regards John "Bob I" wrote in message ... You could have a macro do it. John wrote: Hi Everyone Is it possible to have the "Page Breaks" active all the time. If its by VBA, I would like it too be flexible for one workbook and all workbook if possible. Thanking you in advance. Regards John There is no failure except in no longer trying. Elbert Hubbard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| page breaks | Excel Discussion (Misc queries) | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
![John[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
