I have many command "print" buttons on every page of a workbook. They are invidividually set up to print a specific range. When I use this at home, it works fine, when I send it to a user at work the print functions do not work. I assume because I have a different printer at home then we do at work. Is there a way to automatically print to any computers default printer?
If there is a code that would work, where do I put it?
The print button currently is:
Code:
Private Sub CommandButton1_Click()
ActiveSheet.Range("A1:G9").PrintOut
End Sub
I have seen many examples of different codes but I am not sure on how to use them correctly.
Thanks for your help