Quote Originally Posted by rbrookov View Post
oh wow, thanks!! So the 1st time the user changes the 1st sheet, it pops up the msg box... is it supposed to do that?

And I think it's popping up message boxes for the number of sheets there are - for instance, if there are 3 sheets, then by the time you've made 2 copies, it goes through the loop 2 more times & pops up 3 msg boxes, each w/ the unique name - is that the intent? If so, then that's fine, and I appreciate the help you've give me thus far - it's MUCH better than what I had
It should popup one of two message boxes when you change the combobox and regardless of how many sheets you've already copied.

If the new sheet name was successful, Msgbox 1 asks if you want to make another copy.

If the new sheet name is already used, Msgbox 2 just notifies you of that and the sheet is not renamed. This is in case you accidentally chose the wrong supplier.