I have Excel 2000 and have created a seed sheet with option buttons that a user is to copy to another sheet and then input project specific information. The problem is that the option buttons of all the copied sheets have the same GroupName as the original seed sheet and only one option button can be selected in a GroupName at a time. Thus, if anyone in any of the copied sheets selects an option button, it clears all the option buttons in all the other sheets

Does anyone know how to copy sheets and at the same time have the GroupName change for the option buttons automatically?