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
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?
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
Thanks Ben. Works like a charm!
Corey