This is assuming you are using Form control buttons and not ActiveX control .
If you are not sure the type you are using:
Form Control buttons will be named Button1 etc
Activex control Buttons will be named CommandButton1 etc
You will need to adjust the name of the buttons in the code to match the ones you have.
Insert New Module and paste the code below.
Code:
Private Sub Workbook_Open()
ActiveSheet.Shapes("Button 2").ControlFormat.Enabled = False
ActiveSheet.Shapes("Button 3").ControlFormat.Enabled = False
ActiveSheet.Shapes("Button 4").ControlFormat.Enabled = False
ActiveSheet.Shapes("Button 5").ControlFormat.Enabled = False
End Sub
Put this in the code of the enabled button on startup to turn on button 2
Code:
ActiveSheet.Shapes("Button 2").ControlFormat.Enabled = True
now you just add the same code in button 2 code to turn on the last 3
Code:
ActiveSheet.Shapes("Button 3").ControlFormat.Enabled = True
ActiveSheet.Shapes("Button 4").ControlFormat.Enabled = True
ActiveSheet.Shapes("Button 5").ControlFormat.Enabled = True
Bookmarks