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
Quandan - Marcel Kreijne - 23 Dec 2003 00:51 GMT
Hi Srinivas,
Maybe you could place the images in a password protected database.
Then you do not use hyperlinks in Excel, but buttons for instance, that
call a macro in Excel. This macro then contacts the database and retrieves
the image, which is shown to the user.
This is not 100% waterproof as well, but it's a start... the user might
crack the protection on your VBA code, or might just do a Printscreen
to copy the image shown...
Kind regards,
Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl
> 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
[quoted text clipped - 16 lines]
> Thanks
> -- M