Help: Hyperlinks

M

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?
 
D

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