Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
Print formula in excelPosted 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.
Re: Print formula in excelPosted by Hodge on December 03, 2001 10:21 AM
An easy macro will do you nicely:
Private Sub PrintOuts()
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.