Perhaps by using a macro to loop through your controls and manipulate the
required properties.

--
Regards,
Tom Ogilvy


"Rafat" wrote:

> I have a worksheet that has a dozen option button groups. This sheet is to be
> copied/pasted in the same excel file more than 100 times. Is there a way to
> have the option button groups change there groupname automatically, so that I
> dont end up doing it manually 1100 times.
>
> Thanks,
> Rafat Inayat Elahi