I am looking for a method to add new macros to a file that is stored on a flash drive. I've set all of the computers I use to open this specific file on excel start up to use the macros stored within, but I have not found a method to add macros to this file apart from unhiding the personal macro workbook and this file and then copying them over after they have been created.

Any help would be greatly appreciated, and if there is a more efficient method of handling the addition and use of macros on multiple machines that would be great.