add + suppress command buttons in execution time
 

Hi all,

I have wrote an Excel VBA Macro in witch I have a userform with too many
controls(commandbuttons, togglebuttons, etc.). I want to dynamically create
and suppress at least 4 of the commandbuttons in the execution time.
Does someone have any idea?

Thanks for all.

Ali

add + suppress command buttons in execution time
 

You can just set teh enabled property to false to graey out the buttons or
you can set the visible property to false...

CommandButton1.Visible = false
CommandButton2.Enabled = False

--
HTH...

Jim Thomlinson


"Ali Couran KOTE" wrote:

Hi all,

I have wrote an Excel VBA Macro in witch I have a userform with too many
controls(commandbuttons, togglebuttons, etc.). I want to dynamically create
and suppress at least 4 of the commandbuttons in the execution time.
Does someone have any idea?

Thanks for all.

Ali