VBA for "PrintPreview&Print" in Excel 2010

[SMB Cooper]

VBA for "PrintPreview&Print" in Excel 2010

The Excel2010 shortut key CTRL+F2 displays the Print Preview window. How could I do this in VBA?

 

[Smitty]

You can use:

ActiveSheet.PrintPreview

HTH,

 

[SMB Cooper]

Thank you very much for the prompt reply... unfortunately, the code returns this... (please refer to image below)

AFAIK, the "PrintPreview&Print" feature was only introduced in Excel 2010, so the said UserInterface (as shown in my first post) is really "NEW"???

Googling my way on this issue, I found out that Ctrl+P also displays the NEW Print Preview window.

 

[Smitty]

Oh, you're talking about the "Backstage" view.

I don't know if VBA can access that particular functionality (at least recording a macro indicates that it's not immediately available), which makes me think you might need to access some of the Ribbon's XML properties. It's never occurred to me to mess with that particular property, so I've never tried, but I'm sure that someone can come along and correct me on it.

Ron DeBruin has a good write-up on the Backstage view here: http://www.rondebruin.nl/backstage.htm

Sorry I couldn't answer the question for you.

 

[SMB Cooper]

To whom this may concern:<o></o>
<o></o>
… so after more than 1 year, I tried to check google if the information is now available on theinternet…. this time I used the searchtags “open the backstage print preview in Excel 2010 with VBA” … lo and behold.. it is now available… and the code is…<o></o><o></o>
<o></o>
Application.CommandBars.ExecuteMso("PrintPreviewAndPrint")<o></o>


… so after more than 1 year, I tried to check google if the information is now available on the internet…. this time I used the search tags “open the backstage print preview in Excel 2010 with VBA”
… lo and behold.. it is now available… and the code is…

Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

 

[AlexanderR]

Thanks a lot, this is what i've also been looking for

 

[PatrickOfLondon]

To whom this may concern:<o></o>
<o></o>
… so after more than 1 year, I tried to check google if the information is now available on the internet…. this time I used the search tags “open the backstage print preview in Excel 2010 with VBA”
… lo and behold.. it is now available… and the code is…

Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

I also tried this, and it worked for me:

SendKeys "%FP%", True
​

' = same as pressing in turn the keys Alt, F, P, Alt (to turn back off the little letter labels that appear after the first press of Alt)
​