Hi Friends,

What i am trying to do in the sample file (attached in the question) is:-

- Replicate "Sheet1" each time the green button is clicked with all the questions and option buttons.
- "Sheet1" can be replicated n number of times.
- The option buttons in the new replicated sheet (Say "Sheet2") should not be grouped with the option buttons in "Sheet1".

Error
I have already writen a code to do the above things, but the problem is after replicating the sheet options buttons are grouped with buttons present in "Sheet1". Due to which if after selecting one button in Sheet1 if i create a new sheet and try to click on some option in sheet2 the samme gets unchecked in "Sheet1".

Can anyone help me out for this, i Have used ActivX buttons. also if required you can change the VBA code.

Below is the link for the sample file:-
Ungroup Option button from copied sheet.xls