Run-time error '1004': Method 'Select' of object'_Worksheet' failed

A co-worker has been experiencing this error, for approx. 1 month. This error appears automatically, each time she opens up a particular spreadsheet.
When I select option to "debug" - this is the code which appears:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("Template").Visible = True
Dim mysheet As Worksheet
For Each mysheet In Worksheets
mysheet.Select
mysheet.EnableSelection = xlUnlockedCells
Next mysheet
Sheets("Template").Visible = False
Application.ScreenUpdating = True
End Sub


Is there something here that needs to be corrected?

Thank you,

Thank you. I will give this a try tomorrow and see what happens!

I think this may have been caused by .Select. I think you need to use .Activate to specify that sheet only

ok. Tried the suggestion in regards to 4:12PM post, from yesterday. And she now has a "Compile error: Invalid Next control variable reference"
Should I try the next suggestion - remove .Select and replace with .Activate ? Or do we now have a different issue at this time?
Here is what it looks like at this time:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("Template").Hidden = True

For Each Sheet In Worksheets
mysheet.Select
mysheet.EnableSelection = xlUnlockedCells
Next mysheet
Sheets("Template").Hidden = False
Application.ScreenUpdating = True
End Sub



Thank you,

Thank you XeRo Solus - I copied your code exactly and tried again. It is still giving me the "Compile error"
I previously had the 438 error, and this occurs when you use "mySheet" - when I removed "my" it only gives me the "Compile error"
Not sure what this means. But, still no go. Any other suggestions?

Thank you.

OMG! It worked!! Thank you so much!!