The problem with hiding it is I do not know how many I need to make. I am
returning the names of all the worksheets from another workbook and it will
vary.
For each name retrieved I want an optionbutton (optionbutton1,
optionbutton2...)
I am using the control from the controls toolbox, thanks.


"Dave Peterson" wrote:

You could. But if you have code associated with this optionbutton, it'll get
messy really quickly.

Instead, you could create the optionbutton and hide it. Just make it visible
when you want to see it.

If you need help, what kind of optionbutton is it?

Is it from the Forms toolbar or is it from the control toolbox toolbar?

What's the name of the optionbutton?

And when should it be made visible (and when/if should it be hidden)?

James wrote:

I their a way I can create an option button at run time using vba and place
it on a specific worksheet named "Admin" Thanks.

--

Dave Peterson
.