Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using hyperlinks in a protected worksheet
Is there any way to use hyperlinks to navigate around a large worksheet that
has Protection turned on? I've tried unchecking the "Locked" setting for both the target ranges and hyperlinks, but with Protection on, the hyperlinks don't work. Is there any way to get hyperlinks to function in a protected worksheet? Thanks in advance, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using hyperlinks in a protected worksheet
As a work around you could write macros that do Sheet
("Sheet1").select Range("A20").select as an example. Then use the text or buttons and assign the macros to them. Thanks, Greg -----Original Message----- Is there any way to use hyperlinks to navigate around a large worksheet that has Protection turned on? I've tried unchecking the "Locked" setting for both the target ranges and hyperlinks, but with Protection on, the hyperlinks don't work. Is there any way to get hyperlinks to function in a protected worksheet? Thanks in advance, Paul . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using hyperlinks in a protected worksheet
Greg - I know how to assign VBA procedures to command buttons, but I prefer
the appearance of hyperlinks to the buttons, hence my attempt to use them. Question: you suggested using either "text or buttons." Maybe you're suggesting an alternative that would work for me. I know what you mean by using the buttons, but what did you mean by using "text?" Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks on Protected worksheet | Excel Discussion (Misc queries) | |||
Hyperlinks in cells in a protected worksheet not working | Excel Discussion (Misc queries) | |||
**HYPERLINKS ON PROTECTED SHEET | Excel Discussion (Misc queries) | |||
Protected Hyperlinks | Excel Discussion (Misc queries) | |||
using hyperlinks to navigate around a protected worksheet | Excel Programming |