Does anyone know a way to share an Excel Workbook so that more than 1 person
can have the workbook open and make changes to it and still have Macros work?

If you save it to a sharepoint server only 1 person at a time can have the
document open, but macros work.

If you make the document a shared doocument on the network, multiple people
can have the document open and be making changes, but macros do not work.

There must be a solution to this probem.

Macros will work on shared workbooks.

You just won't be able to see the macros in ToolsMacroMacros.

Assign them to a button or type the name into the Run dialig box.


Gord Dibben MS Excel MVP

On Mon, 9 Feb 2009 17:23:03 -0800, Pats
wrote:

Does anyone know a way to share an Excel Workbook so that more than 1 person
can have the workbook open and make changes to it and still have Macros work?

If you save it to a sharepoint server only 1 person at a time can have the
document open, but macros work.

If you make the document a shared doocument on the network, multiple people
can have the document open and be making changes, but macros do not work.

There must be a solution to this probem.