I want to preview the print AND allow the user to select the printer
I have (2) XL2010 workbooks it works in one but not the other.
In one file with the print area already set up, this previews the print in a Print Preview Tab and when the user clicks Print it gives them the popup window so the user can select a printer. THIS IS WHAT I WANT!
In the other file I’m selecting an area to print via VBA and cannot get this PrintPreview Window
Either of these line give me the Print Preview Tab but upon clicking Print doesn’t give me the popup window so the user can select a printer
This line Previews in the the File tab of the ribbon so the user can change printers, but too often he has to click “Show Print Preview” in order to actually see it,
How can I get the second file to previews the SELECTION in a Print Preview Tab and when the user clicks Print gives them the popup window so the user can select the printer?
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks