Hi Experts ,
I would like to disable an activex button when the user click the closed(x), meaning before closing the excel file. My code seems not working, any idea pls?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).CommandButton1.Enabled = False
End Sub
I would like to disable an activex button when the user click the closed(x), meaning before closing the excel file. My code seems not working, any idea pls?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).CommandButton1.Enabled = False
End Sub