View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jswalsh33 jswalsh33 is offline
external usenet poster
 
Posts: 51
Default Hide a command button

I have a worksheet with command buttons on it. I would like to hide one or
more of these buttons depending on circumstances.

I have tried the code:
Dim Button_Name As String
Button_Name = "Edit"
With ActiveSheet.Buttons(Button_Name).Visble = False

the code is included in a macro that activates the worksheet in question.

When I run this I get an error message: "Unable to get button properties of
the worksheet class"

I am running Excel 2003.

Help?

Thanks

Jim Walsh