2 Printer Icons (Office 2003) 1

[topazdan]

I would like to have 2 printer icons in each of my MS Office programs. (One icon for each of 2 printers).

14 years ago our support person set up 30 computers with such a capability using Win 98. I know that she used macros to accomplish this. However I have since found myself unable to take the time to learn macros sufficiently to repeat this. A Google search for "2 printer icons" offers no solutions.

So, I ask for help here in a simple solution in writing macros to solve this. This solution would also work for a single printer with multiple trays.

BTW, I am amazed that this solution is not already solved by MS or a shareware/freeware vendor. I have seen lots of people asking for this.

Thanks, Dan D

 

[Gavona]

Not quite what you want but maybe will help:

Open Excel; Click on Tools, Customize.

Go to the Commands tab and in the file group I have two printer icons, one says Print..., the other Print (Kyocera ...).
Drag the first of these icons to your toolbar. Using this icon will give you the opportunity, at print time, to choose the printer.
The second Icon always prints to your default printer.

Now if you decide you want both of those on your toolbar you may want to modify one of the button images so you can tell the difference. With the Customise dialogue still open right click on the icon on your toolbar and choose EditButtonImage........


Gavin

 

[topazdan]

Gavin, Thanks.
I checked out your solution.
I tried out your suggestion. It is a little better than what the current situation but not quite there.
I really want 2 dedicated printer icons.
Thanks
Dan

 

[Gavona]

It would indeed be good if you could do that. Hopefully someone will identify the solution. If not and you are willing to use VBA there is probably a code driven solution - so might need a re-post in forum707

Gavin

 

[PeterMoran]

Hi,

Check out this page on the Excel Tips website:

http://excel.tips.net/Pages/T002217_Working_With_Multiple_Printers.html

Good Luck,

Peter Moran

 

[Gavona]

To complete the solution:

In 2003 you can attach a macro as per Peter's link to the printer icon on your toolbar and even customise the icon so you can tell the difference between the two.
Right click in the toolbar area. Choose Customise. Drag printer icon from Commands, File list to your toolbar. Right click on the icon and choose Edit Button Image..... Also Assign macro.

Gavin