View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default 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


.