Print Button

Posted by Sean H. on October 22, 2001 6:24 AM

I made a gif that I inserted into Excel that I intend to use as a button. What code would I use assign the print function/macro to this button?

Thank you kindly in advance,
Sean

Posted by eddie g on October 22, 2001 6:50 AM

activeworksheet.printout
or
activeworkbook.printout

right click the GIF, then click on assign macro

Posted by Sean H. on October 22, 2001 7:14 AM

Thank you Eddie - One more question

Thank you Eddie,

But I have one more question. When I press the button it prints out the pages without the print window coming up. Is there anyway to bring up the print window so that I can choose number of copies etc?

Thanks again, I really appreciate your help.

Posted by EDDIE G on October 22, 2001 8:12 AM

Here you go

YES.......USE THIS INSTEAD

Application.Dialogs(xlDialogPrint).Show

Only the print box will come up.

Posted by Sean H. on October 22, 2001 8:26 AM

Re: Here you go

Thanks alot Eddie!