Programming commands

C

CP

I have just added a couple of buttons to my work book and i wish them to
carry out two tasks
The 2 buttons are on sheet1

1) print sheet3 to default printer
2) close excel without saving or asking to

I am ok with getting to the coding screen however I just dont know what to
write in the visual basic box to perform the tasks

Thank you
 
D

Daniel.C

1.
Sheets("sheet3").PrintOut (beware of the case)
2.
Application.DisplayAlerts = False
Application.Quit
 
P

Per Jessen

Hi

With the two buttons named CommandButton1 and 2 insert theese two
macros in the codesheet for sheet1

Private Sub CommandButton1_Click()
Sheets("Sheet3").PrintOut
End Sub

Private Sub CommandButton2_Click()
ThisWorkbook.Close Savechanges = False
End Sub

Regards,
Per
 
Top