I see what you mean tigeravatar , seems like the workbook is protected some how. I not even sure something like this can be done in Excel, I
just not that good to tell. I will rebuild the book again and start over, will keep it simple to start.I have all the drafts when I started and it shows the data going into B8 to make selection. Thanks again for all your time and I hope you look at new workbook when its done. It will take me a couple days with all the other things I have to do in life. I do think the book is damage some how and no one could fix it.

Z