| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting workbook with hyperlinks
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
'ello?
Sorry - but might have precluded myself from a reply by replying myself -
but I still would love some help please! Thanks Matt "Matt Jensen" wrote in message ... 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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting workbook with hyperlinks
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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting workbook with hyperlinks
Thanks very much Jim - I'll check it out.
Thanks Matt "Jim Cone" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting a workbook | Excel Worksheet Functions | |||
| Protecting a workbook | Excel Discussion (Misc queries) | |||
| Protecting Workbook!.. | Excel Worksheet Functions | |||
| Protecting Workbook | Excel Discussion (Misc queries) | |||
| Protecting a workbook | Excel Programming | |||
Hybrid Mode
