this article explains how to do the screen grab from excel.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075