Kevin,
With regards to your note about synchronization:
I have a single, centrally located macro file that 30+ users access when they log on to the network. A shortcut in their start up folder automatically loads the macro file.
Is there a reason why I would not want to continue supplying the users with the macros in this manner vs. distributing the macro file to each of their PC's? This seems to work well.
When I have updates, I copy my "development" version of the macro file over the "production" version and the next time the users log on they get the new macro file and its contents.
Appreciate the input.