It is my understanding that if i store my macros on a machine in personal.xlsb all the macros in that workbook are available for all the excel workbooks on my machine.

That approach satisfied most people when they had only one machine.

Today, I have several machines, some of which I use in a multitude of geographic locations.

Hence I store data from each machine in OneDrive so that the data is always accessible regardless of where i am. Some of that data is unique to that machine only and hence is stored in a folder associated with that machine.
Some data is common to all machines and is stored in a folder which is copied to each machine when I sync with OneDrive.

My question is where is a good place to store all my macros in one workbook that is available to all workbooks regardless of which machine I am using. In other words, how do i get excel to point to that macro workbook upon startup?

bil