How do I setup a print command button in excel 2003

B

BigPunchy

I want to be able to put a print command button at the bottom of my excel
sheet to print it. It is doing it in visual basic script.
Thank you
 
D

Dave Peterson

Record a macro when you print the worksheet manually.

Then show the Forms toolbar.
Click on the button on that toolbar.
Then click on the worksheet where you want the top left corner to be and drag
down to the bottom right.

When you let go, you'll be prompted for the macro to assign to this button.

Choose the one you recorded.
 
Top