please help
i had created a an excel contains 6 sheets
then i can inserted a macro button to print page 2
the button is on page 3
like this
Private Sub CommandButton1_Click()
Dim myNum As Integer
myNum = Application.InputBox("enter a sheet number")
Worksheets(myNum).PrintOut
End Sub
while clicking on the button i always need to type print 2
is there any other way to just print the selected area of the sheet 2
i need help
Bookmarks