Ok.
Sheet names can almost always be changed and VBA is a little relentless when it comes to the finer points of grammar.
I recommend using the worksheets code name which cannot be changed as easily.

if you look at the little picture you can see that I have a worksheet named "Sheet 1" and it has the code name Sheet1.
I can call the worksheet using any of the following methods:
1) Sheet1.Select (Using Code Name)
2) Worksheets("Sheet 1").Select (Using the Worksheet Name)


Example.jpg


Assuming that you worksheet named "summary" is Code named Sheet1 I would sub in the following code:
 '   Delete temporary dialog sheet (without a warning)
    Application.DisplayAlerts = False
    PrintDlg.Delete
     'SET USERS FOCUS TO WORKSHEET "summary"
     Sheet1.Visible = True
     Sheet1.Select
     
End Sub