I did not understood what you meant by This Workbook but I do now. Thanks for
all of your help. It is working

Bob Phillips wrote:
Did you put it in ThisWorkbook as I described.

I placed this code in my module1 at the end. It does not execute when My
workbook is opened.
[quoted text clipped - 31 lines]

How do I automaticaly execute a Macro when a Workbook is Open?

--
Message posted via http://www.officekb.com