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