VBA code quit working?

[Aron19]

Ive got a command button that I am using in a process that simply quit working. If I run the text through VB it works fine but from the spreadsheet not so much. Any idea of why this is happening and how I can get it to work again?

Private Sub CommandButton46_Click()
Range("A30:V100").ClearContents
CommandButton47.Visible = True
CommandButton48.Visible = True
Range("A30").Value = "19"
Range("A31").Value = "20"
Range("B30").Value = "Does project have potential in other areas to warrant continued development?"
Range("C30").Value = "Are there any other groups within company that could benefit from continued development?"
End Sub

 

[HalfAce]

Check to see if you're in 'Design Mode'.
On the Controls Toolbox toolbar, the small button with the blue triangle, ruler & pencil.
If that button's pressed your routine(s) won't be able to execute.

Hope it helps.

 

[Andrew Poulsom]

In what way isn't it working?

 

[Aron19]

Yea I made sure that I wasnt in design mode and it still doesnt help I dont know why it isnt working haha

 

[Aron19]

All of the other buttons are working but not this one

This button will erase previous text from another choice like it is supposed to but it will not show the text it is supposed to along with the next set of buttons.