Copying Worksheet w/ Radio Buttons

[mrlnmarce]

I am trying to create a macro that will allow me to copy a worksheet
that has a list w/ about 100 rows. Each row has several pull down menus
and two radio buttons (that are linked). When I copy the worksheet
(prior to recording the macro) I lose the functionality of the radio
buttons. When I click on their properties, their linked cell value
references the correct cell on the current sheet.

Any ideas?

Please feel free to email me. I will send a copy of the worksheet.

 

[Earl Kiosterud]

Mrl, Or Marce,

These seem to be radio buttons from the Control Toolbox, but you don't say.
You can send the file if you like. Garbled email address below. (So far no
spam -- been using it for about a month).

 

[mrlnmarce]

I am working from Excel X on Mac OS X. Any idea on how to distinguish
between Control Toolbox radio buttons and others?


Thanks for your help.

P.S. Also tried copying the worksheet with the buttons. It removes
functionality from the old worksheet and gives the radio buttons on the
new worksheet functionality. Any ideas?


I will be sending an email out soon.

M