Print Macro

[Guest]

I'm trying to create a Print Macro that will allow users to choose which
printer to send to rather than automatically sending to thier default
printer. Can anyone help.

Thanks!

 

[NickHK]

Brenda,
You mean exactly as the Print menu option ?

NickHK

 

[keepITcool]

I have a good macro for this..

search google groups for:

list printers
group:microsoft.public.excel.programming
author:keepitcool

or put the next to lines together ...

http://groups.google.com/groups?

hl=en&lr=&selm=Xns94F559246A700keepitcoolnl%40212.83.64.210


the post includes a function that can be used
both as a worksheetfunction of to fill a combobox.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Brenda wrote :

 

[Guest]

Yes.

Brenda,
You mean exactly as the Print menu option ?

NickHK