Thanks for the tips and ideas. I didn't think of putting the finished file
in a separate directory that the user  can access  and keep a working copy in
some other directory so it can be worked on by the authorized people or
person. What you are saying makes it easy to do what I need to do.



I agree that you don't want some virus macro, or unauthorized macro  to run
on the computer. The reason I asked about shutting off the request is that
I was asked by another person who said he didn't even want the users to know
that a macro was running. I can see his point, but I also see and agree
with yours. If a user opens the file  up he should be aware of what is
needed to run  it, otherwise he probably shouldn't be using it anyway.



Thanks again for the information and I will put it to good use. It just
shows that there are many ways to do something and I don't always think of
the best, or easiest, one to use.