MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

An easy macro will do you nicely:

Private Sub PrintOuts()
End Sub

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