Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a forms 1.0 button
Hi,
On recommendation from a textbook I was reading, I used Forms 1.0 toolbar buttons to run macros, instead of using CommandButtons from the Controls toolbar -- a decision I am now regretting. . . Anyway, I am using the following code to temporarily disable buttons created from the Forms toolbar: Sheet1.Shapes.Item(strButton).OLEFormat.Object.Ena bled = False and this does disable the button from calling its OnAction macro. But the button still appears the same, i.e. the text is not greyed out, and when you move the mouse over the button, the pointer icon still turns into the "hand". It is confusing to users, so I would like to make the button's appearance reflect its current state. Is there a way to modify the appearance or behavior for this type of button, other than changing its Visible property to False? Thank you kindly, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding/disabling areas in user forms | Excel Programming | |||
Disabling the standard X-Button? | Excel Programming | |||
Disabling code using a button? | Excel Programming | |||
Disabling Excel X Application Button | Excel Programming | |||
disabling a command button | Excel Programming |