Hi All
I have the below code which will print out a specific sheet with a different printer. This will work as long as the printers don't change. How can I solve a problem if one of the printers gets replaced. Let's say the Canon breaks and is replaced with a different printer. This code won't work anymore.
What can I do to work around this problem.
Please Login or Register to view this content.
Is there a way that when the button on the userform is pressed, the printer properties box comes up and the user can manually select the printer and once printed, goes back to default "Current Printer".
Hi,
You can use
to show the dialog to change printers, and then reset it at the end of the code as you do at the moment.Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks xlnitwit
Perfection as always
A quick question xlnitwit...
How can I suppress the message that pops up with okay and cancel option
What message? Can you provide a screenshot, or the title of the message?
Here you go
MESSAGE-.png
You might try adding an Application.DisplayAlerts = False line but I am not convinced it will work as that is a printer dialog box rather than an Excel one.
Yeah tried that but no avail....Thanks for your time xlnitwit
Please help xlnitwit
I have a huge problem....
The below code brings up the attached image. When I click cancel, all my installed printers gets deleted. This has happened 3 times already. Any ideas.Untitled-1.png
Please Login or Register to view this content.
I have no idea why this is happening
Which version of Windows and excel are you using?
Windows Ultimate and excel 2007
Windows Ultimate which version? (Regrettably if this is an Excel 2007 bug I imagine you will be out of luck now)
Hi xlnitwit
I am using Windows 7
Hi sintek,
Maybe this will be of some help; http://www.mrexcel.com/forum/excel-q...t-printer.html
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
So....Does this mean that I am not able to use this code:
Is there another solution perhaps?Please Login or Register to view this content.
Hey there Winon
That code, when used, deletes my installed printers, as per previous post explanations.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks