VBA code to have print button and print the required area in sheet.

Hi All,
I have created a macro that formats the sheet as desired. I want the formatted sheet to show the Print button.
This need to be part of macro that is formatting the sheet so that once sheet is formatted it should have the Print button on it.
On click event of print button I need to print area A2:J33 in A4 page, landscape orientation.
It should be a single page, comments are not needed to be printed.
Print dialogue box should be available to user , either to select the active printer or to print as PDF.

I tried inserting a button and assign the recorded print macro. It works, but than user has to every time manually assign a macro to a button, which I am trying to avoid.

Thank you for the help in advance.

Interesting. Can you post your workbook here so we can see what is happening ?

Hi AlphaFrog,
Thanks for answering the question.
I have added the button as per above code and assigned the recorded Macro1 to it.
But some how the Macro1 selects required range A2:J33 but it does not pop up the print view settings.
This will help user either to select active printer or print as PDF. Attachment has the recorded Macro1.
Please help.

Hi AlphaFrog,
I have edited the code. Please refer the Macro2 code in module 2.
Print preview is now visible.
Appreciate your time on this.
Thank you.