pushbutton to print all sheets

  • Thread starter Jean-Paul De Winter
  • Start date
J

Jean-Paul De Winter

Hi,
I would like to have a pushbutton on the first sheet so I can print
all sheets of the current workbook...
How can this be done??
Thanks
JP
 
F

Frank Kabel

Hi
assign the following macro to a button:
sub foo()
activeworkbook.printout
end sub
 
Top