Hmmm. The Wikipedia article about Office 2011 says "Support for Visual Basic for Applications macros returned after having been dropped in Office 2008." But maybe there are exceptions.
http://en.wikipedia.org/wiki/Microsoft_Office_for_Mac_2011I'm afraid I can't offer any debugging ideas, but maybe someone with the same program could look at the macro code and figure out the problem.