While doing a little research on this question I found a thread that addresses this problem. Andy Pope has an addin available for exporting pictures from excel:
http://www.andypope.info/vba/gex.htm

Let me know if you find it useful. Sounds like exactly what your looking for.