Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
I run Excel 2003 with VBA 6.5
I have been given a file which looks strange. The pages of the active sheet have Page 1, Page 2, ... Page n on them when viewed in Excel. I Googled and worked out that this is because I am looking at the Page Break Preview of the active sheet. My first wrong thought was that I was looking at a watermark (A semi-transparent shape). I can get out of this by clicking Normal View in File/Print Preview. I tried recording a macro to do this but only recorded ActiveWindow.SelectedSheets.PrintPreview I want code to identify that I am looking at a Page Break Preview and to set Normal View. I am afraid that Google groups Advanced Search (<http://groups.google.co m/advanced_search?num=100&q=&) just shows me a title rather than a form at the moment; This limits my helping myself. I have recently seen other reports of the same Google problem. Thanks! -- Walter Briscoe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
hi Walter,
ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView -- isabelle |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
also,
If ActiveWindow.View = xlPageBreakPreview Then ActiveWindow.View = xlNormalView -- isabelle Le 2011-09-06 10:45, isabelle a écrit : hi Walter, ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
on 9/6/2011, Walter Briscoe supposed :
I run Excel 2003 with VBA 6.5 I have been given a file which looks strange. The pages of the active sheet have Page 1, Page 2, ... Page n on them when viewed in Excel. I Googled and worked out that this is because I am looking at the Page Break Preview of the active sheet. My first wrong thought was that I was looking at a watermark (A semi-transparent shape). I can get out of this by clicking Normal View in File/Print Preview. I tried recording a macro to do this but only recorded ActiveWindow.SelectedSheets.PrintPreview I want code to identify that I am looking at a Page Break Preview and to set Normal View. I am afraid that Google groups Advanced Search (<http://groups.google.co m/advanced_search?num=100&q=&) just shows me a title rather than a form at the moment; This limits my helping myself. I have recently seen other reports of the same Google problem. Thanks! Why not just add NormalView/PageBreakPreview buttons next to the PrintPreview button on the toolbar? If you use XL2007 or later its already on the View ribbon, Workbook Views section. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
Typo...
Why not just add NormalView/PageBreakPreview buttons next to the PrintPreview button on the toolbar? If you use XL2007 or later its already on the View ribbon, Workbook Views section. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
In message of Tue, 6 Sep 2011 10:48:31
in microsoft.public.excel.programming, isabelle writes also, If ActiveWindow.View = xlPageBreakPreview Then ActiveWindow.View = xlNormalView Precisely what I wanted! Thanks! -- Walter Briscoe |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
In message of Tue, 6 Sep 2011 11:54:23 in
microsoft.public.excel.programming, GS writes Typo... Why not just add NormalView/PageBreakPreview buttons next to the PrintPreview button on the toolbar? If you use XL2007 or later its already on the View ribbon, Workbook Views section. Thanks for your efforts, Garry. I wanted something in VBA code. isabelle gave me what I wanted: If ActiveWindow.View = xlPageBreakPreview Then ActiveWindow.View = xlNormalView -- Walter Briscoe |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Page Break Preview
Walter Briscoe formulated the question :
In message of Tue, 6 Sep 2011 11:54:23 in microsoft.public.excel.programming, GS writes Typo... Why not just add NormalView/PageBreakPreview buttons next to the PrintPreview button on the toolbar? If you use XL2007 or later its already on the View ribbon, Workbook Views section. Thanks for your efforts, Garry. I wanted something in VBA code. isabelle gave me what I wanted: If ActiveWindow.View = xlPageBreakPreview Then ActiveWindow.View = xlNormalView Yes, I realize Isabelle met your request. I just find it most convenient to have the button on the Formatting toolbar because I use it quite a lot. It's easier to click it there than open the macros dialog or use a submenu added to an existing menu.<g -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical page breaks won't drag 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) | |||
Remove big gray page number on Page Break Preview??? | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) |