"Urgent" use script to share the workbook

Hi all,

I have this case
I put the excel file .xls in the server, and use some vba script to protect
the workbook and add some validation too, now when the user open this .xls,
it copy the workbook to the user local harddisk c:\program file\.....somewhere
so when the user save the xls, it only save to its harddisk, not the server
one

Any professional can tell me what should I do ?
It is a urgent case for me >_<

Thanks very much

Hey man,

Consider this. If users did save back to the server (if it let them), it'd
overwrite changes made by other users who saved earlier. Have you
considered using Tools, Share workbook?
--
Earl Kiosterud
www.smokeylake.com

"man" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> I have this case
> I put the excel file .xls in the server, and use some vba script to
> protect
> the workbook and add some validation too, now when the user open this
> .xls,
> it copy the workbook to the user local harddisk c:\program
> file\.....somewhere
> so when the user save the xls, it only save to its harddisk, not the
> server
> one
>
> Any professional can tell me what should I do ?
> It is a urgent case for me >_<
>
> Thanks very much