Managing Printing

  • Thread starter Thread starter darusman
  • Start date Start date
D

darusman

Hi,

I want to create a form which should open when i hit the print button
in excel and then it should give me option that which printer i want to
use from the number of network printers installed on my pc. And when i
click the printer name on the form it should print my spreadsheet. I
want to access this function in every spreadsheet which i use.

Any Help will be appreciated.

Thanks,
 
Isn't that what File>Print.. already does ?

But if you must :
- Intercept the printing in the Workbook_BeforePrint event
- Show your form
- PrintOut
- Unload the form
- Cancel=True

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epson XP-3150 not printing 2
Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
Epson Printer Problem 6
Copy cell change to other workbook 5
Managing Printing 1
On some PC's prints to default windows printer rather then Acrobat PDF defined in code 1
How to program print preferences 2
print 2 sheets on one paper 5

Back
Top