vba command

[Sijo Stephen]

i have an excel sheet. i need to put one print command cutton in
sheet 2 for printing sheet 1.any command for that ?can u help me ?

 

[snowjoke]

Try recording a macro where you add the button and see what it comes up with...

 

[Sijo Stephen]

I tried somany times.its working for one sheet, but i need to print sheet one from sheet 2

 

[snowjoke]

You need to create a macro and assign it to the button. If you start recording the macro when you're on sheet 2 that should capture the switch of sheets.

If you don't want to see the sheets changing just edit the code produced to something like:

Sub printSheet1()
    Sheets("Sheet1").PrintOut Copies:=1
End Sub

Assign the macro to the button and you're done.

 

[Sijo Stephen]

its not working

 

[Sijo Stephen]

i need to print sheet one from sheet 2 , any command for that