Use the beforeclose and beforesave events to enforce/control what you want.
http://www.cpearson.com/excel/events.htm
for an overview of events if you are not familiar.
--
Regards,
Tom Ogilvy
"jen" wrote in message
...
Is there a way to 'force' the user to save the file using a required name?
I
am sending out a template to 70+ users and need to pull in the data per
the
filename I want. Any help would be appreciated.
Thanks!