see this web page and modify the macros

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