Question

excel vba 打开窗体的时候让按钮不可用

这样为什么不行了？
Private Sub Workbook_Open()
Load UserForm1
UserForm1.Show
UserForm1.CommandButton1.Enabled = False
UserForm1.CommandButton1.Enabled = False
UserForm1.CommandButton2.Enabled = False
UserForm1.CommandButton3.Enabled = False
UserForm1.CommandButton4.Enabled = False
End Sub

Answer 1

userform1.show

放在最后

Private Sub Workbook_Open()
    Load UserForm1
    With UserForm1
        .CommandButton1.Enabled = False
        .CommandButton2.Enabled = False
        .CommandButton3.Enabled = False
        .CommandButton4.Enabled = False
        .Show
    End With
End Sub

追问

试了，不行啊

追答

你的操作系统版本,excel版本