When my workbook opens, I want it to open on a specific worksheet, and hide a few of the rows in that worksheet.

My code is:
Private Sub Workbook_Open()

ThisWorkbook.Sheets("Guide").Activate


ThisWorkbook.Sheets("Guide").Rows("9-60").EntireRow.Hidden = True
 
End Sub
I get mismatch error in the hide rows line of this macro and cannot work out why? Any ideas?