View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walter Briscoe Walter Briscoe is offline
external usenet poster
 
Posts: 279
Default 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