I have a workbook that on one of the sheets I have several drop down boxes. I first created the list say in A1 thru A5. Then the drop down would be in B1. Now whenever I go to copy that sheet I get a message box that pops up that says :

A formula or sheet you want to move or copy contains the name 'name', which already exists on the destination worksheet. Do you want to use this version of the name?

All I have to do is click yes and it all copies over ok, but the problem is that there are nine drop downs. I copy the sheets a lot and everytime I do I have to select yes nine times. Is there a way around this?

Thanks