Hi, thanks Bob, but I really want the endusers to be automatically directed
to a different folder, and the same one. Knowing them as I do, they will
save in their My Documents, create new folders etc.

When they make changes to the read-only folder, I want them to HAVE to save
the new document to a specific folder. If I just tell them, they'll do their
own thing.

Thanks
Charlotte


"Bob Phillips" wrote:

Activeworkbbok.SaveAs "C:\Finance\WIP\" & Activeworkbook.Name

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Charlotte Howard" wrote in
message ...
Hi,

I have created 2 workbooks that are password protected so that end users
can
only open a read-only copy. They will need to save a copy for themselves,
which I want them to do in a particular folder on the network.

The Workbook templates are in /finance/valuations, and the workbooks
should
be saved in /finance/WIP

any help appreciated,
Charlotte