This works correctly if you open excel and create a new workbook from within.
When you open excel twice from the start menu it opens in a separate instance and you lose some functionality when you try to go between the two and you can't access macros from workbooks in the other instance.
Not really sure why this is or what the limitations are, I would be interested in understanding it as well.
Jesse
Bookmarks