Hidden hyperlink within excel

[Srinivas Chundi]

Using VB6, I have created an excel spreadsheet. Some cells contain a
hyperlink to TIF image files on a specific server within the LAN. When the
user clicks on any one of these cells, it launches a copy of Imaging
software and displays the image the hyperlink is pointing to.

Is it possible to let the users view the images, like they are currently
doing, without giving them direct read access to the specific location where
the image files are located? I need to do this to ensure that the users do
not view/access the images by any means other than clicking on the
hyperlink. Also, the location of the images should be hidden from them and
they should not be able to edit or copy/paste the hyperlink to a different
software, such as word. In essance, the users should not know where the
images are actually located and they should not be able to get to them by
any other means, say using windows explorer or word.

It is really important that I accomplish something as close to this as
possible.
Any help is greatly appreciated.
Thanks
-- M

 

[John Walkenbach]

You could write a VBA macro and attach it to a button. The macro would
launch your imaging software and load the file. The file location would
appear only in the VBA code.

But when the image software opens, isn't the file path accessible there? I
really doubt that there's much you can do to thwart a user who really want
to know the file location.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss