I would save the Personal.xls macro file as an Add-in(*.xla) and have the users
point to that file in its common folder when loading it through ToolsAdd-ins.

When saving as an add-in change the name to something like Group_Macros

Store it in the common Office\Library folder and it will be available for all to
load, use and edit if necessary.

Note: editing must be done through the Visual Basic Editor.


Gord Dibben MS Excel MVP


On Mon, 30 Oct 2006 11:33:01 -0800, ivanfloyd
wrote:

I would like to set up a personal.xls file that can be shared between two or
more people. This would need to be in a common or shared directory that all
users would have access to execute, modify and add to. The purpose is that
in our workgroup everyone backs up everyone else.