Maybe hiding it would work better.

ListBox1.Hide

If they can't see it they can't use it.
"ExcelMonkey" wrote:

I have a userform. I want to prohibit the user from one of the listboxes at
certain times. I know I can set the .Enabled propterty = False. But how to
you grey out the listbox?

Thanks

EM