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