View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Ultimate Control

What you're asking for is an OS-level piece of functionality: Excel cannot
"watch" what folk do in Explorer when it's not running.

This is really a job for a document management system.

Tim

"Steven" wrote in message
...
Thank you for your responses. That is not what I am saying. What I want
to
do is when I create a file, we will call it "File001.xls", in excel there
should be a property that says that only the creater of the file can a.)
"copy" over the file or b.) take a different file and save it over the
file.

Now, from within the file File001.xls a user can save the file but could
not
Save As to anything else. The ultimate key is that, for example, say a
user
is in File002.xls and they try to do something like save File002.xls to
File001.xls then the system should say,

"You cannot save over File001.xls from another file...the creater of the
file has blocked the ability to overwrite the file from the outside. This
file can only be updated and saved by properly opening the file and
working
within the file." The same would hold true if they tried to copy over the
file in Explorer or in the Excel dialog box or delete the file. If this
cannot be done I believe it is an overall weakness in excel that needs
changed.

Steven