Thread: "Force" user to save file with specific name

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!

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" <jen@discussions.microsoft.com> wrote in message
news:C52C688D-69A4-4B5A-8D67-5A9ACB8902E3@microsoft.com...
> 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!