Printer Selection Box
I'm working on a project that will eventually be used by
multiple users. I have a macro to print out a selection of graphs, and it works great. Then I realized the users will need the ability to change the printer (ie: to the color printer)instead of it just invoking the default printer. Since each user is connected to a different set of printers, the only solution is to have the macro bring up the printer selection box before executing the print function. Is there a way to do this? Thanks in advance for any help I can get! Susan |
Printer Selection Box
Application.Dialogs(xlDialogPrinterSetup).Show
-- Regards, Tom Ogilvy "Susan Lund" wrote in message ... I'm working on a project that will eventually be used by multiple users. I have a macro to print out a selection of graphs, and it works great. Then I realized the users will need the ability to change the printer (ie: to the color printer)instead of it just invoking the default printer. Since each user is connected to a different set of printers, the only solution is to have the macro bring up the printer selection box before executing the print function. Is there a way to do this? Thanks in advance for any help I can get! Susan |
Printer Selection Box
Another option is:
Application.Dialogs(xlDialogPrint).Show but that would be less specific. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Application.Dialogs(xlDialogPrinterSetup).Show -- Regards, Tom Ogilvy "Susan Lund" wrote in message ... I'm working on a project that will eventually be used by multiple users. I have a macro to print out a selection of graphs, and it works great. Then I realized the users will need the ability to change the printer (ie: to the color printer)instead of it just invoking the default printer. Since each user is connected to a different set of printers, the only solution is to have the macro bring up the printer selection box before executing the print function. Is there a way to do this? Thanks in advance for any help I can get! Susan |
Printer Selection Box
Yes, thank you for your help. That's exactly what we were
looking for! -----Original Message----- You might be looking for: Application.Dialogs(xlDialogPrinterSetup).Show "Susan Lund" wrote: I'm working on a project that will eventually be used by multiple users. I have a macro to print out a selection of graphs, and it works great. Then I realized the users will need the ability to change the printer (ie: to the color printer)instead of it just invoking the default printer. Since each user is connected to a different set of printers, the only solution is to have the macro bring up the printer selection box before executing the print function. Is there a way to do this? Thanks in advance for any help I can get! Susan . |
All times are GMT +1. The time now is 05:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com