Help: Hyperlinks

[Monte Comeau]

Hi,

I have a problem with my hyperlinks not working after I protect the sheet.

These are hyperlinks that go to other parts of a large sheet. I have a
hyperlink that goes to a differnet sheet in the same workbook that works
fine after protection is enabled.

These hyperlinks are assigned to buttons I made with the Autoshapes feature.

Any ideas?

 

[Dave Peterson]

I just tried this in xl2002 and it worked fine with the worksheet protected.

But maybe you could assign a macro to your shape:

option explicit
sub myLineClick
application.goto worksheets("sheet2").range("b2"), scroll:=true
end sub

kind of thing.


What version of excel are you using? Maybe MS improved it (or you may want to
give another shot to see if works now.)

 

[martialtiger]

i believe you would need to assign the link using a macrobutton. at
least this is how i did it on word. then you using the FollowLink
macro.

Check this out

'HyperLinks In Protected Forms'
(http://word.mvps.org/FAQs/TblsFldsFms/HLinksInForms.htm)

Good Luck!