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 4 · Answer 1 · answered Feb 21 '19 at 14:39

4

You may also try

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

answered Feb 21 '19 at 14:39

Harun24hr

18,374
3
16
28

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,315
2
12
20

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

2 Answers2

Linked