Printing Active Sheet with command button

[iturnrocks]

I have a command button on Sheet4 that says Print

When the user clicks the button, I want it to have the effect of Clicking File, Print

I dont actually want it to print, I just want it to go to the window where you can choose the printer and how many copies.......



Thank you

[VBA Noob]

Hi,

Does this help

Please Login or Register  to view this content.

VBA Noob

[iturnrocks]

That works, thank you

[VBA Noob]

No problem

Glad it helped

VBA Noob