Calling up Print Menu with VBA

  • Thread starter Thread starter jeffcadle78
  • Start date Start date
J

jeffcadle78

Using MS Excel 97:

I'm about to send an excel file off to my boss, but before I do so, I'd
like to add a Button that will print everything in the workbook.

The VBA code to print everything is all set.

My issue is as follows:

I want to have the VBA code pull up the print menu (CTRL+P),
and then let him select the printer he's hooked up to.

So basically, I just need a way to call up the menu.

Thanks in advance for any help you can give.
 
Back
Top