print preview macro

I have managed to wangle together this VBA code to select & print preview certain worksheets from the workbook. It works great, but I want to exclude certain sheets from the list. I am hoping some VBA guru here can help me out please? Sub Print_Sheets() Dim i As Long, c As Long Dim...

I am trying to replace "Selection.PrintPreview" with "Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")" but I am missing the "Selection" component. How do I preview the selected range with the new print preview window?

I use VB to Excel Macros to generate reports. The application can print to a PDF File or display the report in Excel Print Preview. When displaying the report in Excel the VB application remains in the foreground. The Excel Print Preview is called from a macro. The application waits for the...

I use code to perform a Print Preview. This works just fine in 2000 to 2010 (.xls). However, when this was moved to Excel 2013 (.xlsm) it no longer works as desired and in fact halts the VBA Code. I have been looking and looking for a solution but have yet to find it. Can anyone help. Here is...

Hey, I want a macro to display print preview of multiple worksheets of an excel file. I've a macro that is basically displaying the preview of just one worksheet. But i want a macro that can display the preview of say 4-5 worksheets in a big excel file of say 30 worksheets. The Macro I'm using...

I use a closed ribbon on my worksheet so how would I write a macro 2 just open 2 a print preview 2 wait 4 a command???:confused::rolleyes: Thanx 4 any help!!!

Hi I am trying to do a print preview macro that will print to the end of active text. Right now I can only figure out how to print to the certain number that I specify. Ex. On three diff documents one has cells going 50 down, another 150, one 500. I would like for the macro to recognize the...