sorry, missed the button is on the worksheet and not a
userform...




-----Original Message-----
This is from the Forms toolbar?

Worksheets("Sheet1").Buttons("cmdEnterData").Visi ble =
True

There's another property that you might like,
too: .enabled = True/False

The button will still be there, but won't do anything if
you click it.

Paul James wrote:

I need to be able to hide and display a command button
depending on the
occurrence of certain events. What code can I use to
hide and display a
command button named "cmdEnterData"?

Thank you in advance.

--

Dave Peterson

.