Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I have a worksheet with a button on it that I called "undoButton". How can I now set the Enabled property of this button from a macro? I did the following and it "almost" works ... ActiveSheet.Shapes("undoButton").Select Selection.Enabled = False The only problem is that it selects the button which will be confusing for the user. I then tried ActiveSheet.Shapes("undoButton").Enabled = false but that wouldn't work. How can I access the properties of the button and change them? The ActiveSheet.Shapes("undoButton").Locked = true worked ... why not the Selected? Thanks! Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |