View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default Enabled Property of Shapes?

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