Customize Ribbon (Add Button / Assign Macro) in Excel 2010

First off, I apologize if this has been posted previously (which I am sure it has). I searched and didn't find the thread.

I am assuming it is possible to assign a macro from the shared drive to a button.

I am going to Customize Ribbon / Choose Command from: / Macros

And all the only option that I see is my Personal workbook?

I can't figure out how to browse any path other than in my personal workbook..


Thank you.

Not sure if this is the answer but:

Excel Book I was attempting to link to had the modules password protected. Once I opened that specific book, unlocked the module I was able to view the macro in Customize Options.