Page Break Preview

[juan]

Hi,
this could be a simple thing but having problems.
I want to do print preview then do the Page break preview
so that I can make sure the sheet will fit accordingly.
I try recording a macro doing File, print preview, page
break preview but when I run the macro,it seems to take me
to print preview but doesen't do the page break thing.

Can anyone help?

thanks,

juan

 

[Norman Jones]

Hi Juan,

Try:

Application.Dialogs(xlDialogPrintPreview).Show

 

[juan]

Hi,
This will just bring me to the print preview. Which is not
the problem. The problem is that I'm trying to get to the
Page break view and drag to where I want it. Example, I
did this
Sheets("lines by").Select
Application.Dialogs(xlDialogPrintPreview).Show
ActiveSheet.VPageBreaks(1).DragOff
Direction:=xlToRight, RegionIndex:=1
ActiveWindow.View = xlNormalView
But the macro will bring me to the Print Preview and stays
there. So if I hit the close button or page break button,
it seems as if the macro runs.
Hope I'm clear. Please provide any more input if you see
the problem.
Thanks,

Juan