Hi all, I'm trying to create a macro that will hide a sheet and unhide a different sheet and select a cell in the unhidden sheet. I keep getting a run-time error of 1004.
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Sheets("SMT Selection Process").Visible = False
Sheets("Employee_List").Visible = True
Sheets("Employee_List").Select
Range("A1").Select
End Sub
It doesn't like the "Range("A1").Select, I'm using Excel 2007.
Thanks guys.
Bookmarks