Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / December 2003

Tip: Looking for answers? Try searching our database.

Scure Hyperlink!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Srinivas Chundi - 03 Nov 2003 21:56 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.