Make CommandButton on userform appears grayd out

[hmk]

Hi there

How to make a commandBottun on a userform appears not active(grayd out) untill certain action is performed, then the commandbar Bottun will be active(Not grayd out) ?

 

[acw]

Hi

You could either:
1) in the properties for the button on the form, change the enabled to false
or
2) use the userform_initialize code to change the enabled to false.

As part of the code accompanying the "action", you can then change the enabled from false to true.

HTH

Tony

 

[hmk]

Thank u veru much