Run-time error '1004' Select method of range class failed

When I am in an excel document and I click on a hyperlink to take me to another excel document when it opens the second document I get the above error. I can either click on end or help. Continue and Debug are grayed out. How can I get rid of this error? Any help would be much appreciated. Thank you in advance.

sounds like the excel document you are using may have been created on a later version of excel, and that there may be a reference missing in the VBA reference section. The file is protected and thats why you cant get the full error or fix it.
You will need to go back to who ever designed the workbook to get them to unlock it or sort the error out.

Sean

Thanks Norie and Sean, I created the both documents. I have them protected because we seem to have people like to go in and change things and they create more issues. I did unprotect the document and I don't get the error now, but I need to have the document protected or people will just go in and change whatever they want to change and I have tons of hyperlinks in the documents. Do either of you have any other suggestions? Thanks!

I think, is there a way to check for sure?

I think I have another code in there. It is the following:

Private Sub Workbook_Open()
Sheets("Summary").Activate
End Sub
That way when someone goes into the workbook it goes to the Summary page. Could this be the problem.

Yes, the codes are in the workbook the hyperlink opens. I am not sure how to commnet out both sets of codes. Here are the modules for this workbook.

Sub ProtectAll()

Dim wSheet As Worksheet
Dim Pwd As String

Pwd = InputBox("Enter your password to protect all worksheets", "Password Input")
For Each wSheet In Worksheets
wSheet.Protect Password:=Pwd
Next wSheet

End Sub

Sub UnProtectAll()

Dim wSheet As Worksheet
Dim Pwd As String

Pwd = InputBox("Enter your password to unprotect all worksheets", "Password Input")
On Error Resume Next
For Each wSheet In Worksheets
wSheet.Unprotect Password:=Pwd
Next wSheet
If Err <> 0 Then
MsgBox "You have entered an incorect password. All worksheets could not " & _
"be unprotected.", vbCritical, "Incorect Password"
End If
On Error GoTo 0

End Sub

If you have unprotected the workbook and all is ok, then you must have some code in there which locks or unlocks. When you say you unprotected it, was that for the workbook or the VBA?
can you post the workbook? it would be easier to look at the code for you.

Sean