Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Hyperlink Back | Excel Programming | |||
Back door into locked form | Excel Programming | |||
how do i go back from a hyperlink ? | Excel Discussion (Misc queries) | |||
hyperlink: back to last worksheet | Excel Worksheet Functions |