I have a couple of macros in my personal.xls that open when I open excel.
However, there are reports that are brought in from another application and
opened with excel. When the spreadsheet opens that way, these macros are not
available.

They are definately in my personal.xls and i've also made it an addin. I
can't find a way to activate that add-in. Any suggestions? I'd like to make
these available to the rest of my dept as well. I've even thought of adding
a menu item.