I have 2 desktops and a laptop. All user files are on dropbox, which is mapped to drive B: on each pc so that a macro on each PC looks at the dame file. (this is due to different disk configurations on each pc).
I have to date used Personal.xlsb as the repository for macros I want to use on each PC , Each PC therefore has to have its own version of Personal meaning I have to copy changes from one to the other two. Quite doable but irritating!
I also have some UDF's that I put into an xlam add-in that I use with all 3 PC. I have a feeling that If I move all those macros in Personal into the shared XLAM file then no need for 3 versions of personal. Any comments as to (unseen by me) complications arising from this approach?
You'll probably need a menu system for running those macros, since macros in an add-in do not appear in the macros dialog.
Thanks for the confirmation Veloria. I found that out the hard way and had real trouble removing old versions of my add-in from the add-in manager. Even starting excel with run as administrator did not work.. Finally I edited the registry and got rid of "OPEN" Dwords referring to the not required files. The up side of it is that I have found I can copy Personal.xlsb from one PC to another rather than having to export/import vba module files 🙂
