Just a follow up Michael

This code only runs if / when the workbook is actually opened.

Also, here's some Websites that have some great codes which you may find
handy....

Ron DeBruin: http://www.rondebruin.nl/tips.htm
Chip Pearson: http://www.cpearson.com/Excel/Topic.aspx
Debra Dalgleish: http://www.contextures.com/tiptech.html

HTH
Mick