Thread: [Solved] Print preview and print dialog
View Single Post
 
Old 07-21-2020, 02:02 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Print preview and print dialog
Back again,
Still trying to sort out this printing option,
When i select File then print, I get the print and print preview dialog, I also get this if I hit CTRL P on the keyboard.
But if i use - Application.SendKeys ("^P") in VBA it brings up the format cells dialog.

How do I get the print and print preview dialog displayed using VBA ????
Reply With Quote