Can Excel 2011 and Excel 2016 work from the same macro workbook source on OSX?
<p>This may be extremely specific, but I use macros a lot in my job. We recently got Excel 2016 for Mac in my office, which is universes better than Excel 2011 except for the VBA editor which has taken a huge hit in functionality and ease of use.</p>

<p>Lately, I've been editing macros using my Excel 2011 personal macro workbook then copy/pasting all code over to my Excel 2016 personal macro workbook, which can be a hassle and is prone to error at some point in the future. Is it possible to have 2011 and 2016 source from the same personal macro workbook, so that when I edit in 2011, it automatically changes what is used in 2016?</p>

<p>If someone has a solution for this, this could also potentially be a great way to share regularly updated macros among co-workers.</p>