[I posted this in the programming section, but I just realized that there's another section for Excel 2007 issues...]

There's probably a very simple solution out there, but 30 minutes of googling led me to nowhere...

I'm trying to reference an add-in that I've written to a new blank workbook.

Back on Excel 2002, I would simply do the following:

1 - Open Excel with a new blank workbook
2 - Open VB Editor (Alt+F11)
3 - Tools->References
4 - Browse to the add-in and add it.
5 - Save the workbook
6 - Close Excel and reopen the workbook.

However, when I do this in Excel 2007, the reference is not saved. In other words, when I reopen the workbook, it doesn't remember to reference the add-in. I saved the workbook as .xlsm (macro enabled), but I've tried others as well; none worked.

Any suggests or assistance would be greatly appreciated.

Thank you.