VBA Form Control Button Needs to Disappear After Another Button is Clicked

Question

So I have a Form Control Button NOT and ActiveX Command Button that I want to make disappear when another button is clicked. Normally if it was a ActiveX Command Button i would use:

ButtonName.Visible = False

in the code that was triggered by the other button. However I dont know how to get that work with a Form Control Button as they dont have name like a ActiveX Command Button does so far as I know?

I would just change the button I want to disappear to a ActiveX Command Button but when I do that I have issues with the buttons format changing, text sizes up when they are clicked, buttons change size when clicked, etc.

Is the button on a sheet or a userform? – Mistella Feb 21 '19 at 14:29 — Mistella, Feb 21 '19 at 14:29

score 3 · Answer 1 · answered Feb 21 '19 at 14:39

3

You may also try

Sub Button2_Click()
    Sheets("Sheet1").Buttons("Button 1").Visible = False
End Sub

answered Feb 21 '19 at 14:39

Harun24hr

30,391
4
21
36

score 1 · Accepted Answer · answered Feb 21 '19 at 14:22

1

.Shapes("button 1").Visible = False

answered Feb 21 '19 at 14:22

Nathan_Sav

8,466
2
13
20

VBA Form Control Button Needs to Disappear After Another Button is Clicked

2 Answers2

Linked