Vacuum Sealed brought next idea :
Hi everyone

Here I am again looking for help.....

I have a reasonable well functioning code that does almost everything I
need, with one exception.

5 different people access this file and print the same report, the glitch
is that they each are assigned a different Printer Port (Via the Citrix
Server) to the printer in our office.

I was toying / hoping I could use a pup up with the 5 options for each to
select their printer ports and have that inserted into the module into the
section of code so that the Macro would run it's course.

Really looking forward to your suggestions and Ideas.

Cheers

TIA
Mick

Normally, Excel defaults to whatever printer the user has set to be
their default printer. Would this then not be their respective printer
port location?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc