Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Print formula in excel

Posted by Nima on December 03, 2001 8:42 AM

How can i print for example sheet week1, week2, and week 3 at a click of a button.

What is the formula, or procedure.

Many thanks

jj008@gre.ac.uk

Re: Print formula in excel

Posted by Hodge on December 03, 2001 10:21 AM

An easy macro will do you nicely:

Private Sub PrintOuts()
Worksheets("week1").PrintOut
Worksheets("week2").PrintOut
Worksheets("week3").PrintOut
End Sub

You make a button with this code using the "Control Toolbox", or just run it from the macro menu.

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.