The answer to your first question:
"Is there a way to make sure the Auto_run macro  is run... without ... "yes" or
"no"...."
is "NO"... the whole idea is to ensure that a file  that has a virus macro does
not run  without
the user  approving the macro. The certification  is to get past this. There is
a "selfcert" that has
limited utilization... but there's no getting past it. And, as a software
developer, and a victim of
viruses, I don't WANT it to be easily bypassed!!!

For your second question... Are you saying that your file renames itself after
the user opens it.
But you want specific users to be able to overwrite the original  file?
First of all, I ALWAYS make my changes in a "Development" file. The changes I
make are sometimes
extensive, and I may have to save the document at an incomplete condition. In
which case, I don't
want the user to call up the in-process file... Therefore, my auto_run macro
checks to see if the
current path name (activeworkbook.path) is the "Development" folder. If not,
then it proceeds with
the rest of the macro. I also have another "File_Release" macro that does a
"savecopyas" and overwrites
the "Released" file.. Tip: use .attributes=0 to set  the write flag on the
file, overwrite the file, then set
the attributes = 1 in order  to make it read-only for the users. That way, the
users cannot have the file
open when you're trying to overwrite it.