Hi,

I'm using a combo box in a userform and using "Add Data" in the VBA code to
populate the drop down options...so far so good. However I'm having
difficulty selecting the correct properites of the combo box, to prevent the
(human) user from selecting & editing the options in the drop down, when the
userform appears. Everything I try prevents the dropdown from actually,
well..dropping down.

Also, is it possible to disable or make invisible a button on a worksheet
when a condition arises (say a cell changes to a preset value). I can make
the button "grey out" or disappear on a UserForm, but I can't see how to do
it if it's on a worksheet. OK, I could set a condition in the code for it not
operate if pushed, but "greying out" would be neater.

Thanks...Chris