I don't use xl2007 very much, but I don't recall that the VBE interface has
changed much from xl2003.

So I'm guessing that you're confusing excel's VBE with MSWord's VBE.

DaveD wrote:

I have some macros I use in multiple workbooks defined in my personal.xlsb
workbook. Some of my other projects have a folder listed called "references"
in which it shows a link to personal.xlsb, I haven't figured out how to get
this folder to show up.

I've tried to add the reference using "tools-reference" menu as well as
dragging the personal.xlsb project onto the current project. I always get the
"duplicate name" error and it doesn't get added.

Thanks,
Dave

--

Dave Peterson