Share with multiple users allowing macros

**19Rowy85** · 10-09-2008, 01:03 AM

Hi,

A question that I would really appreciate some help on, I have been looking for a long time with no success...

I have a workbook that I would like to share and allow multiple users to add and make changes at the same time. However, the workbook is full of macros that really need to run. Is this possible? The workbook is written in excel 2003...

If this is not possible then is it possible to share the workbook in a similar fashion but not allow any other users to make changes, but update their workbook with the changes that I make?

I haven't found anything yet that looks like it will let me do this, but I am still hopeful. Any help would be greatly appreciated.

Many thanks...

**Richard Buttrey** · 10-09-2008, 03:07 PM

Hi,

And welcome to the forum,

There is inbuilt functionality which allows you to share workbooks, but at the end of the day, when you need to combine them someone has to decide which when two changes clash, which one should take priority.

It all depends on whether the users are allowed to make changes to the same areas. If not then you could use the sharing functionality, or indeed write a macro which can access all the individual workbooks and copy and paste the various areas into a consolidating workbook.

HTH

**19Rowy85** · 10-09-2008, 06:14 PM

Thanks for that, I thought that might be the answer.

Think I will try having a workbook on each computer and a shared file as a database, see if I can get that to do what I want..

Appreciate your help...