Printting Dilemma

G

Guest

I have several network printers available to print to,
they're all listed in excel. I would like to set up two
different icons on my desktop toolbar, because each
printer has different capabilities. Is there a way to do
this? Each time I set up an icon for a printer, when I
shut excel down, it goes to my default printer. Can you
help?
 
P

Paul B

You could record a macro when you print to the prints and then assign it to
a button on your tool bar, if you put the macro in your personal folder it
will be available to all your worksheets
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
G

Guest

Thank you Paul, I appreciate you getting back to me.
Problem is, I don't know how to set up macros, can you
direct me?
 
P

Paul B

To record a macro go to tools, macro, record new macro, pick if you want to
store it in this workbook or your personal workbook, now just go though the
steps you do when you print the sheet, you may also want to set the printer
back to the default one, when you are done stop recording. To run the macro
press Alt+F8 and select the macro from there, you can also assign it to a
button. For some more information you might want to take a look here.
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
P

Paul B

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Top