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 |
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 |
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 . |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com