Hello folks,

I've searched about a bit for an answer to this with no luck, so if it's been covered before please forgive me!

I have a spreadsheet used for maintenance inspection checks. Each row represents each individual inspection check and contains four mutually exclusive option buttons in a group, representing Pass / Fail / NA / Incomplete.

I have a macro which successfully copies and inserts numerous rows in the event that each piece of equipment may have sub-systems (so each check/row is required more than once), however my problem is this - the option buttons are not copied with the rows. Or they may be copied but certainly not inserted. I have tried linking the buttons to the cells with no result. I have however noticed that on running the macro excel automatically exitsdesign mode which I would imagine you need to be in to create new buttons, even in a copy/insert scenario.

Can anyone advise with a solution?

Please note, on creation of a new row with four buttons, these four buttons would need to be in a seperate new group of their own. The buttons I'm using are from the controls toolbox as opposed to the forms toolbar.

Thanks all!