Hi, I have 28 excel sheets in a workbook. There is one main form in workbook. When i click on one button 3 spreedsheets become visible.I need a button on each sheet, so that I can print out other sheets. How come I do that.
Thanks a lot
I have used the following code......It will show print preview of page..because this sheet is for different people in Australia...So I could not use .printout...because they have to select there own printer..so I showed only print preview....Any more suggestions????....
Private Sub cmdPrintSiteSurveyEnergy_Click()
Dim SiteSurveyEnegy As Integer
' message box to prompt print out
SiteSurveyEnegy = MsgBox("Do you want to take print out of Site Survey Energy Sheet", vbYesNo + vbInformation, "Print Out")
If SiteSurveyEnegy = vbYes Then
With Worksheets("3.0 Site Survey Energy Print")
.Visible = True