Transferring Excel Macro Workbook & Excel Ribbon to multiple users

Originally Posted by General_Gin

I copied the macro Workbook in another user's Excel autostart - "XLSTART" Folder.

OK

Originally Posted by General_Gin

I installed the ribbon and tried to access the macros but it should error - that the proper path was not found.

You probably did this by exporting your ribbon customizations to a *.exportedUI file. Open this file in Notepad. There you should see entries like:

onAction="C:\Users\user_profile\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!Macro1"

Probably it is enough to change the "user_profile" fragment to the correct one. Unless the computer has a different Personal.xlsb location. Correct all paths you find in the open file. Then save it and import it in Excel.
A much better solution is to create add-in *.xlam. Then you don't have to worry about changing the location of macro paths, because everything will be in one file. And macros and ribbon elements. In add-in, it's best to build your own ribbon (you can add groups and icons to existing tabs or build your own Tab). This requires at least some basic knowledge of ribbon construction. Useful ribbon editing tools: "Custom UI Editor For Microsoft Office", "RibbonX Visual Designer" (written by Andy Pope). Book "RibbonX: Customizing the Office 2007 Ribbon" (by Martin, Puls, Hennig) and of course the entire Internet.

Artik