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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top