Can you add a button to a spreadsheet to Print?
 

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?

Can you add a button to a spreadsheet to Print?
 

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"

"Pam Dupre" wrote:

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?