View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N E Body N E Body is offline
external usenet poster
 
Posts: 34
Default Stop an excel file from being moved or copied - do I validate filepath?

Hello

I have an Excel file on a shared drive for everyone to access. Its a sort
of database where everyone keeps adding to it. Originally I set up a
shortcut on all desktops to access the file and all went well.
Lately information was missing, person A said they had entered the details
but when I accessed the file it was not there - somehow they had a copy of
the file on their desktop so the info never reached the file on the shared
drive.

How can I stop my file from being copied or moved. My best thought was to
have some sort of validation on start up, probably checking the filepath was
correct. I dont have a clue how to do this!!

Any assistance or other suggestions would be appreciated.

TIA

Kenny
using XP pro and office 2003