I know this is a really old post, but I found it while I was looking for a solution to the exact same problem. I have a client who refuses to move on from 2010 and found myself dealing with this. Here's what I did to get it to work.
go to on_open, it should say [embedded macro] open the macro...