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