Excel 2003: Printing a worksheet and setting properties

A

Amanda

Howdy all:

I have a worksheet that when I hit a button (wheter it's the default print
button or just a command button), I want it to go to a printer on my network
(that is not default printer), and have several options/properties set. For
example, it's a locked print (with name '123SI' and password '123'), in
color, bypass tray entry, standard tray as exit tray, and the paper type to
'Thick 1'.

I don't even have a clue where to start - I tried to record a macro as I
printed one day, and it seem to record anything useful. Any and all
suggestions are welcomed!
 

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

Problem with printing a word document containing a table 0
Set up and printing a 4-up mail merged postcard 0
Page numbering with Merged Document and IF statements 1
Word 2010 macro for printing to tray2 0
Printing first two pages in Tray 1 and subsequent pages in Tray 2 1
Printing Word document from bypass tray of printer. 1
Excel won't print 2
Upgraded from Win 7 to Win 10. Publisher printing black. 1

Top