vba macro for print button that brings up print screen selection window

Hi there,

I'm afraid the code you've posted (which seems to work correctly ) isn't much use to us - we need to see the code for the routine "ON_CLICK_PRINT" which is apparently in your "PERSONAL.xlsb" workbook.

Regards,

Greg M

I believe that is where I am not understanding how to get the print button to work once the spreadsheet is emailed to the user. The on click is in my personal so how does one get it into the workbook that is being emailed?

[Sub ON_CLICK_PRINT()
Application.Dialogs(xlDialogPrint).Show
End Sub]

Hi again,

Thanks for that information.

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M