Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Preview
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Preview
Hi Juan,
Try: Application.Dialogs(xlDialogPrintPreview).Show --- Regards, Norman "juan" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Preview
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 -----Original Message----- Hi Juan, Try: Application.Dialogs(xlDialogPrintPreview).Show --- Regards, Norman "juan" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Hiding the page number in page break preview background. | Excel Discussion (Misc queries) |