Ya, doing your first example is not viable because sometimes the
macros get run alone. I found a similar solution after some digging
(which is a little more useful) at http://www.excelguru.ca/node/54

Thanks for the help!