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

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.