Can you add a button to a spreadsheet to Print?

P

Pam Dupre

I am trying to add a button to a spreadsheet that I have made into a order
form, I would like to add a button that says "Submit" and have it print to a
certain printer when pressed, then when it prints have it say "Sent". Can
this be done in Excel?
 
B

bigwheel

The easiest way would be to Record a Macro, then assign the macro to a button.

Click Tools, Macro, Record New Macro. Then follow the normal steps to get a
print i.e. click File, Print then choose the printer to be used and click OK.
Click the Stop Macro button. Create a button and assign the macro to it.
Edit the button caption to read "Submit"
 
Top