View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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