"Urgent" use script to share the workbook

M

man

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
 
E

Earl Kiosterud

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?
 
Top