How do I create a Print button in an Excel Spreadsheet?
snitches get stitches
Joined: May 2002
Posts: 49,696
Likes: 1
From: Portland, OR
Dude, you need to learn to be self sufficient...you did get your MBA, right?
1-Open a new workbook.
2-From the Tools menu, choose Customize.
3-Click the Commands tab and then scroll down the left-hand Categories column and select Macros.
4-You’ll see Custom Button in the Commands box. Click, hold, and drag the custom button onto any toolbar and release.
5-Right-click the new button and choose Assign Macro.
6-Choose HeaderFooter and click OK. You may now change the button icon by right-clicking the button, choosing Change Button Image, and clicking on another icon.
7-Close the Customize dialog box.
1-Open a new workbook.
2-From the Tools menu, choose Customize.
3-Click the Commands tab and then scroll down the left-hand Categories column and select Macros.
4-You’ll see Custom Button in the Commands box. Click, hold, and drag the custom button onto any toolbar and release.
5-Right-click the new button and choose Assign Macro.
6-Choose HeaderFooter and click OK. You may now change the button icon by right-clicking the button, choosing Change Button Image, and clicking on another icon.
7-Close the Customize dialog box.
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
Originally Posted by RB
Dude, you need to learn to be self sufficient...you did get your MBA, right?
1-Open a new workbook.
2-From the Tools menu, choose Customize.
3-Click the Commands tab and then scroll down the left-hand Categories column and select Macros.
4-You’ll see Custom Button in the Commands box. Click, hold, and drag the custom button onto any toolbar and release.
5-Right-click the new button and choose Assign Macro.
6-Choose HeaderFooter and click OK. You may now change the button icon by right-clicking the button, choosing Change Button Image, and clicking on another icon.
7-Close the Customize dialog box.
1-Open a new workbook.
2-From the Tools menu, choose Customize.
3-Click the Commands tab and then scroll down the left-hand Categories column and select Macros.
4-You’ll see Custom Button in the Commands box. Click, hold, and drag the custom button onto any toolbar and release.
5-Right-click the new button and choose Assign Macro.
6-Choose HeaderFooter and click OK. You may now change the button icon by right-clicking the button, choosing Change Button Image, and clicking on another icon.
7-Close the Customize dialog box.
Thanks for the help. I got my MBA but it was not an MBA in Excel. Never had a class or even a book to look at in Excel. This is pretty complicated Excel stuff which I have been working on for anyone, especially for someone who has never had an ounce of training on the program or its codes.
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
Originally Posted by Eklypse39
you're going to have to activate macros and use vb code.
i did this years ago, and i'll look for directions if you really need it.
i did this years ago, and i'll look for directions if you really need it.
Thank would be great Andrew
Thread Starter
Senior Member
Joined: Mar 2002
Posts: 16,353
Likes: 0
From: Ossining, New York
RB the button the want is actually something they want on the spreadhseet and not in a tool bar. They want it to be easy so someone presses a button that says "print" and the pages will print. I guess selecting the printer icon is too hard for people to do lol. It is funny how these people who sell computers can barely work them. Tool bars are too confusing for them