i thought what i said did exactly what you want...if you send your file as a
template instead of a normal excel workbook,when the third party clicks the
icon for your file it automatically opens as a copy,ie say your workbook is
called Dolores it will open as Dolores1,the original Dolores is "untouched"
--
paul
remove nospam for email addy!



"Dolores" wrote:

Thank you for your suggestion, Paul. It is not exactly what I would like to
find.

"Copy the file first," "SaveAs immediately," and using a template all
require giving instructions to the user. I had hoped to find something that
would be invisible to the user.
--
Dolores


"paul" wrote:

save your file as a template rather than an excel workbook.I save my
templates in the same place as the original workbook.When you open a template
it opens as a copy of the original.
--
paul
remove nospam for email addy!



"Dolores" wrote:

Is there a way to copy a file automatically on opening it, before any changes
are made to it (to be used as a failsafe in case the user does not save it
before opening it or before they open and change it, and then want to use it
again)? That is, I want to email a file to someone and, when they open the
file, I want a copy of it to be made automatically, so they will have it to
use again at another time. (I dont know if it would make any difference, but
a macro is contained in this file.)
--
Dolores