Setting up a basic Macro is a bit like recording a tape - Excel will convert all of your steps into computer code.
To put in Print Button, follow these steps:
On the menu bar, go to Tools/Macro/Record New Macro/ give it a name "Print Form"
Then a small box will appear on your sheet - ignore this for the moment.
Now go through all the usual steps you would go through to print a sheet e.g. select File/Print etc.
When you have done all of that, go back to the small box on your sheet and click on the square - that will stop the Macro Recording.
You have now recorded a Macro that will Print your sheet. Now you have to connect this Macro to a button.
Go to View/Toolbars and click on "Forms".
Select the icon that reads "Button" when you hover over it. Then move your mouse to the position on the sheet where you want the button to sit. Click&Drag your mouse to the size of button you want.
When you let go of the mouse, a box will appear, with your "Print Form" macro in it. Select the "Print Form" macro and click OK.
Close the Form Toolbar. Right mouse click on the Button and change the text to read "Print Form".
You've now created a Macro and assigned it to a button. If you want to see the program code that has been created when you recorded your macro, go to Tools/Macro/Visual Basic Editor, double click on "Modules", then double click on "Module 1" - this is your VBA code.
Cheers!
