ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I setup a print command button in excel 2003 (https://www.excelbanter.com/new-users-excel/4711-how-do-i-setup-print-command-button-excel-2003-a.html)

BigPunchy

How do I setup a print command button in excel 2003
 
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

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.



BigPunchy wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com