Print Preview through command button/Shape

[azad092]

Hi
i have a data entry sheet including an interface sheet. on the interface sheet, I want to see the print preview for each sheet through clicking on the button/shape name for example
by clicking on Shape 1>> I want to see the sheet1 print preview
by clicking on Shape 2>> I want to see the sheet2 print preview
by clicking on Shape 3>> I want to see the sheet3 print preview
and so on....
Please guide me what I have to do

 

[Jaafar Tribak]

thanks for reply
yes....form label

where is the label ? Is it on a userform or on a worksheet ?

 

[Jaafar Tribak]

Private Sub Label1_Click()
    Unload rpftForm
    ThisWorkbook.Worksheets("G Report").PrintPreview
End Sub

 

[azad092]

Private Sub Label1_Click()
    Unload rpftForm
    ThisWorkbook.Worksheets("G Report").PrintPreview
End Sub

great work.....thanks alot dear