I have two worksheets in my workbook. I want to create a “Print” button on Worksheet 1 (the worksheet that I use to enter data) that will print Worksheet 2.
I know how to create a print “button” on my Worksheet 1, but I have no idea how to write the code to print Worksheet 2.
I do not want the computer screen to change from Worksheet 1 upon execution of the print command.
Also, I would want to know how to enable the macro.
If there is someone who can help a guy who has no knowledge of VB programming, I’d appreciate it. Thank you for any help you can be.