MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print Button Icon


Posted by Corey on June 26, 2001 8:32 AM

I would like to assign a print macro to a button. Is there a way to use a printer icon for the button?


Posted by Ben O. on June 26, 2001 8:49 AM


Is this going to be a button on a toolbar? If so, when in Tools > Customize mode, right-click on the Print button and select Copy Button Image. Then right-click on your macro button and select Paste Button Image. You can also edit the image if you want to make it a little different.

-Ben

Posted by Corey on June 26, 2001 8:57 AM

Thanks. Actually, I would like to place the print button on a specific sheet. Do you know if I can use a printer icon for this print button?

Posted by Ben O. on June 26, 2001 9:08 AM

Yes, you can insert a graphic of the printer icon in the worksheet and then assign your macro to it. It would have to be a graphic though, since buttons can only go on toolbars. You could get a graphic that looks just like the printer icon by taking a screenshot, cropping it, and saving it as a .bmp.

-Ben

Posted by corey on June 26, 2001 10:30 AM

Thanks Ben. Works like a charm!

Corey