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:
I get mismatch error in the hide rows line of this macro and cannot work out why? Any ideas?Private Sub Workbook_Open() ThisWorkbook.Sheets("Guide").Activate ThisWorkbook.Sheets("Guide").Rows("9-60").EntireRow.Hidden = True End Sub