Button to print "Sheet2" with formatting

Posted by D. Pencille on January 17, 2002 7:07 PM

I need to have a button on "Sheet1" which will print data on "Sheet2". Can it also set the print area, header, and margins?

Have very limited knowledge of VB (next to none).

Posted by Ivan F Moala on January 17, 2002 8:46 PM

If you know how to do this manually then
Plan out the steps, turn your macro recorder on
and follow the planed steps.
Select an object and assign the newly created
macro to it.

Further help required / the repost.

Ivan