print from a comand button
Posted by M.A on April 02, 2001 12:47 PM
Im working on a three page workbook,what i would like to do is place a comand button on page three of the workbook that when pressed will print page one of the workbook
is this possible?
cheers,M.A
Posted by Dave Hawley on April 02, 2001 12:52 PM
Hi M.A
Place a Command button from the "Control Toolbox" on your Sheet, double click it and paste in this code:
Private Sub CommandButton1_Click()
Sheets(1).PrintOut
End Sub
Dave
OzGrid Business Applications
Posted by M.A on April 03, 2001 1:09 PM
cheers dave,
M.A
