Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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

Re: Print Button

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

Thank you Eddie - One more question

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

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.

Here you go

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

YES.......USE THIS INSTEAD

Application.Dialogs(xlDialogPrint).Show

Only the print box will come up.

Re: Here you go

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

Thanks alot Eddie!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.