i have a problem to write a coding using VB in excel. actually i have to create a button in excel which is the button is use to print a spreadsheet in excel...for the example..when i click the button..it can automatically print out the spreadsheet...can u help me solve dis problem..tq.

mysheet.printout

can u help me..can u teach me how to start it..because dont know what is the first thing to write that code..
start from...

Private Sub CommandButton1_Click()

End Sub

how i want to start it..can u teach me plizz..

Private Sub CommandButton1_Click()

mysheet.printout (as posted above..this can be , for example Sheet1.printout)

End Sub

go out of design mode, and click on your commandbutton