Button show hide on load of excel

[mmittal]

Hi,

I have an excel file with 5 buttons and each of them has a separate vba module but I want to display only one button on load of an excel. Other 4 buttons should load on click of the fifth button which was visible.

Can anybody please guide me how to get this thing done?


Thank you

 

[Steve_]

Hi,

I have an excel file with 5 buttons and each of them has a separate vba module but I want to display only one button on load of an excel. Other 4 buttons should load on click of the fifth button which was visible.

Can anybody please guide me how to get this thing done?


Thank you

Create a form. Put two buttons on it. Paste this code...

Private Sub CommandButton1_Click()
    CommandButton1.Visible = False
    'CommandButton1.enabled = False   ' This is useful too.
    CommandButton2.Visible = True
    ''CommandButton2.enabled = true
End Sub
Private Sub CommandButton2_Click()
    CommandButton1.Visible = True
    'CommandButton1.enabled = true   ' This is useful too.
    CommandButton2.Visible = False
    ''CommandButton2.enabled = false
End Sub

That should get you going.

 

[mmittal]

Thanks Steve. I'm new to vba so I may be wrong. I already have an excel sheet and that sheet has some buttons. Those are buttons not the command buttons. When I enter your code, I get debug thing.

 

[mmittal]

Thanks Steve. I'm new to vba so I may be wrong. I already have an excel sheet and that sheet has some buttons. Those are buttons not the command buttons. When I enter your code, I get debug thing.

I got this with the following code:
Dim shp As Shape
Set shp = ThisWorkbook.Worksheets("Sheet1").Shapes("Button 3")