I was wondering if Workbooks.Open would be the answer.

I'll need to think on how to do this; something like your suggestion.

I have the tools needed to do the coding; I just wanted to confirm that
there wasn't a "built-in" mechanism available before I did so <smile.

To answer your question, no the path is not always the same, and I have
the links in an auto-filter list so I can manipulate it at will.
Neither are insurmountable problems, tho.

Thanks for the answer!

Clif

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
How many of these do you have and do they all point to same path but
different workbook?

I'm thinking of an alternative to Hyperlinks.

Workbook names only in cells and event code to select a cell, open the
workbook read-only or not depending upon code.

Sample code.............in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim mypath As String
mypath = "C:\Program Files\Microsoft Office\Exceldata\"
Select Case Target.Address
Case "$E$4", "$E$5", "$E$6"
Workbooks.Open Filename:=mypath & Target.Value, ReadOnly:=True
Case "$E$7", "$E$8"
Workbooks.Open Filename:=mypath & Target.Value
End Select
End Sub


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 12:37:27 -0500, "Clif McIrvin"
wrote:

Excel 2003 SP3 on XP Pro SP3

I have a workbook I have created to use as an index to infrequently
used
workbooks using hyperlinks to create a point and click Document Index.
It works well for why I created it; now I'd like the ability to encode
some of the links to open read-only instead of read-write. I didn't
find
anything in the help files ... is this possible?

Thanks in advance!

Clif