Printing using user prompts

[tmmich71]

I'm new to visual basic and teaching myself so I need help often . Can anyone help with a code that will select predetermined worksheets and then ask the user to choose the printer (they're on a network) and the number of copies? I'm not sure if I'm explaining this well enough, but I hope that its a simple program.

Thanks so much for any help!

 

[Von Pookie]

Assuming you're using Excel XP (2002) at the latest, you can bring up the Printer dialog box, just as if they selected it from the file menu:

Application.Dialogs(xlDialogPrint).Show

They can choose printers, number of copies, etc.

 

[tmmich71]

Thanks! I knew it was something simple, but i just don't have a grasp of all the language yet.