[SOLVED] Protecting workbook with hyperlinks

Howdy
A range 1 column by about 30 rows of my workbook contains cells with text
and hyperlinks to the internet for the text. For this example's sake, I want
to entirely protect the worksheet but have users able to click the
hyperlinks.
So I unlock the range in question, protect the worksheet and check the
checkbox for 'select unlocked cells', which works fine and you can click the
hyperlinks and IE will open and browse to correct page, but if you click
anywhere else in the workbook (i.e. on locked cells) the last selected
hyperlink is then opened!!!!
How can I prevent this happening?
Thanks
Matt

If I could get the cell with the text/hyperlink that was clicked to be
'unselected' after opening the hyperlink all would be great. I had a play
with FollowHyperlink event but with no success
what am I missing?
Thanks
matt

"Matt Jensen" <[email protected]> wrote in message
news:%[email protected]...
> Howdy
> A range 1 column by about 30 rows of my workbook contains cells with text
> and hyperlinks to the internet for the text. For this example's sake, I
want
> to entirely protect the worksheet but have users able to click the
> hyperlinks.
> So I unlock the range in question, protect the worksheet and check the
> checkbox for 'select unlocked cells', which works fine and you can click
the
> hyperlinks and IE will open and browse to correct page, but if you click
> anywhere else in the workbook (i.e. on locked cells) the last selected
> hyperlink is then opened!!!!
> How can I prevent this happening?
> Thanks
> Matt
>
>

Sorry - but might have precluded myself from a reply by replying myself -
but I still would love some help please!
Thanks
Matt

"Matt Jensen" <[email protected]> wrote in message
news:[email protected]...
> If I could get the cell with the text/hyperlink that was clicked to be
> 'unselected' after opening the hyperlink all would be great. I had a play
> with FollowHyperlink event but with no success
> what am I missing?
> Thanks
> matt
>
> "Matt Jensen" <[email protected]> wrote in message
> news:%[email protected]...
> > Howdy
> > A range 1 column by about 30 rows of my workbook contains cells with
text
> > and hyperlinks to the internet for the text. For this example's sake, I
> want
> > to entirely protect the worksheet but have users able to click the
> > hyperlinks.
> > So I unlock the range in question, protect the worksheet and check the
> > checkbox for 'select unlocked cells', which works fine and you can click
> the
> > hyperlinks and IE will open and browse to correct page, but if you click
> > anywhere else in the workbook (i.e. on locked cells) the last selected
> > hyperlink is then opened!!!!
> > How can I prevent this happening?
> > Thanks
> > Matt
> >
> >
>
>

Matt,

Interesting, a couple of ideas...
1. Leave the locked cells as selectable when protecting the sheet.
The user still cannot change the cells.
2. Same as above but...
leave a blank cell unlocked ("A1") ?
add the following code to the sheet module...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.Intersect(Target, Me.Range("A2:A30")) Is Nothing Then
Me.Range("A1").Select
End If
End Sub
'--------------------------------

Regards,
Jim Cone
San Francisco, USA


"Matt Jensen" <[email protected]> wrote in message news:#[email protected]...
> Howdy
> A range 1 column by about 30 rows of my workbook contains cells with text
> and hyperlinks to the internet for the text. For this example's sake, I want
> to entirely protect the worksheet but have users able to click the
> hyperlinks.
> So I unlock the range in question, protect the worksheet and check the
> checkbox for 'select unlocked cells', which works fine and you can click the
> hyperlinks and IE will open and browse to correct page, but if you click
> anywhere else in the workbook (i.e. on locked cells) the last selected
> hyperlink is then opened!!!!
> How can I prevent this happening?
> Thanks
> Matt

Thanks very much Jim - I'll check it out.
Thanks
Matt

"Jim Cone" <[email protected]> wrote in message
news:[email protected]...
> Matt,
>
> Interesting, a couple of ideas...
> 1. Leave the locked cells as selectable when protecting the sheet.
> The user still cannot change the cells.
> 2. Same as above but...
> leave a blank cell unlocked ("A1") ?
> add the following code to the sheet module...
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Application.Intersect(Target, Me.Range("A2:A30")) Is Nothing Then
> Me.Range("A1").Select
> End If
> End Sub
> '--------------------------------
>
> Regards,
> Jim Cone
> San Francisco, USA
>
>
> "Matt Jensen" <[email protected]> wrote in message
news:#[email protected]...
> > Howdy
> > A range 1 column by about 30 rows of my workbook contains cells with
text
> > and hyperlinks to the internet for the text. For this example's sake, I
want
> > to entirely protect the worksheet but have users able to click the
> > hyperlinks.
> > So I unlock the range in question, protect the worksheet and check the
> > checkbox for 'select unlocked cells', which works fine and you can click
the
> > hyperlinks and IE will open and browse to correct page, but if you click
> > anywhere else in the workbook (i.e. on locked cells) the last selected
> > hyperlink is then opened!!!!
> > How can I prevent this happening?
> > Thanks
> > Matt
>