Hi I have a simple code:
However instead of printing I want it to come up the with printer options so each time I can select the correct printer in the office. See picture below.Please Login or Register to view this content.
print.JPG
Cheers
Hi I have a simple code:
However instead of printing I want it to come up the with printer options so each time I can select the correct printer in the office. See picture below.Please Login or Register to view this content.
print.JPG
Cheers
.
Please Login or Register to view this content.
Hi thank you, but how do I get it to print sheet "Print" not the sheet the button is on
.
You posted an image of the Printer Dialog Window ... so ... I presumed that was what you were seeking. Although convoluted you can :
You select the PRINT RANGE / PAGES (From / To)
Each sheet has a number assigned to it. Look in the VBE where the sheets are listed to determine the sheet number.
I also presume you can use the PrinterDialogWindow to select the desired printer, close the window and continue using your original macro to print
the desired sheet.
===========================
However, if you review Chip Pearson's website you can learn how to use a small macro to see what printers are available and select one
as active, then you should be able to continue using your original macro for printing. Here is the link to Chip's website :
http://www.cpearson.com/excel/GetPrinters.aspx
The example .XLS zipped file is down the bottom of the page or you can download it here as the attachment.
===========================
You can also hardcode the desired printer in your macro (making it the active printer) and continue on with your original macro.
This macro will bring up a small window where you can select the desired printer (hopefully it will show your networked printers), then brings up the PRINT PREVIEW window,
then prints the sheet you have hardcoded into the macro (your original sheet name).
===========================Please Login or Register to view this content.
One of these approaches will work ...
Last edited by Logit; 08-12-2018 at 07:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks