Multiple log in & update a file that contain Macro

[winxmun]

Hi!
How to allow multiple log in for updating a file that contain Macro? I tried to save as Share Workbook but encounter error & Macro is disabled.
Anyone can help!!! tks a lot. :dunno

Regards
winxmun

[tstav]

In my experience this multi user update issue in Excel has proved very problematic, causing loads of confusion to users.
I would suggest to avoid letting more than one users update the same file at the same time (or find other ways to cope with this).

One way I can think of is to automatically create a local user_copy of the file (e.g. on the user's hard disk) and let the user update it and then save it back to a specified (shared) folder.

I'd be very interested to hear from others on their experience on this.

[winxmun]

Hi tstav, I'm interested on your method. May i know how to do this? tks.