Hyperlink Back w/ locked worksheet

[dgold82]

I have a large file with dozens of worksheets. With the help of the community
I was able to find a simple macro that would help a user hyperlink back to
the origin using the following code (I have back buttons scattered
throughout):

Sub goback()
Application.Goto
End Sub

Here is the problem: 4 of my worksheets are locked WITHOUT allowing the user
to select cells (has to be that way because of a number of macros that run on
that page and input is all radio buttons...long story).

How can I use the above code to go back on a page that is protected from
selecting locked cells? I tried to add an unlock procedure, something like:

Sub goback()
..Unprotect Password:="test"
Application.Goto
..Protect Password:="test"
End Sub

BUT with no luck. Help would be much appreciated!! Thanks.

 

[Gary''s Student]

You need to unprotect the destination worksheet. Since it might be any of
the 4 protected sheets, consider:

1. unprotect all 4 protected sheets
2. do the goto
3. re-protect all 4 sheets

This way you do not have to determine if your destination is protected or not.

 

[dgold82]

Thanks, Gary. That is what I was thinking but I couldn't figure out how to
manipulate the macro to do that. What am I doing wrong below?