I suppose that I can't really enforce their always saving the workbook in the
correct folder, but if the initial save as goes to a specific folder, then
they are more likely to save in that location.

If I prevent them from saving in the valuations folder themselves, then they
are likely to save it willy-nilly where-ever their fancy takes them. If I
present them with a specific folder, they are more likely to save it there.

Charlotte

"Bob Phillips" wrote:

How do you propose to force that? Unless you take control of their
environment, and the saving, you cannot stop them browsing to wherever they
wan t to go.

--
HTH

Bob Phillips

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

"Charlotte Howard" wrote in
message ...
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