Hyperlink Back w/ locked worksheet
 

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.

Hyperlink Back w/ locked worksheet
 

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.
--
Gary''s Student - gsnu200859


"dgold82" wrote:

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.

Hyperlink Back w/ locked worksheet
 

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?

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200859


"dgold82" wrote:

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.