View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.