Hi
don't think this is possible. They can make a copy of the sheet locally
but changes in this local copy are NOT reflected in the shared
workbook.

--
Regards
Frank Kabel
Frankfurt, Germany


TroyH wrote:
I am creating a workbook that will reside on a network drive. There
will be approx. 15 different users accessing this workbook. Here is
my delima:

The workbook does this:
Users will be creating multiple pages which will be copied and
deleted from shared workbook when they close. Users will have the
ability to add certain data to only 1 sheet of the shared workbook.

I have a few users who are very paranoid and want the abilty to save
the workbook locally in case of a power outtage, etc.

How do I stick with a single shared notebook but allow users the
option of saving locally and keeping the data on the one single sheet
active.

Thanks.