Perhaps it's time to upgrade to Excel 2011 for the Mac. It has VBA abilities.