Option Button Name Changes When Copied To New Worksheet

  • I have two option buttons (Designerbutton1 & Designerbutton2), when I copy them and paste them to a different worksheet their names change to Optionbutton# (# = next available number). Anyone know why & if I can prevent this. I cannot have a code that says Optionbutton16 should be renamed to what I want it to, because right now 16 is the next available # but what if I add an Optionbutton16 later on my own.

    Ed
    [SIZE=6]*ficus*[/SIZE]
    Thanks to all for making this website work!

  • Re: Option Button Name Changes When Copied To New Worksheet


    Hello, Foxxy1!


    Are you copying this button through code or manually? I don't quite understand what the problem is. Is it that you want the pasted button to have the same name as the copied button? What kind of button is it?


    Mac

  • Re: Option Button Name Changes When Copied To New Worksheet


    It's a control option button that I'm copying through code. The names is one thing when copied, then when pasted on another sheet, the pasted option button name changes.

    Ed
    [SIZE=6]*ficus*[/SIZE]
    Thanks to all for making this website work!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!