Hyperlink Back w/ locked worksheet


D

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

Advertisements

G

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

Advertisements

D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top