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.
|