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

1.
Sheets("sheet3").PrintOut (beware of the case)
2.
Application.DisplayAlerts = False
Application.Quit
--
Regards.
Daniel
"CP" a écrit dans le message de news:
...
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

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

On 15 Okt., 12:15, CP wrote:
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