I have an open event in an Excel workbook that after Saving the workbook as a new name, I want to disable the sub. The disable would occur with a click event on a button on the SignIN Form. Is this possible?
Here's the code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("DCNTemp").Select
Range("AZ2").Select
ActiveCell.Value = ActiveCell.Value + 1
Range("a1").Select
ActiveWorkbook.Save
Load SignIn
SignIn.Show
End Sub
Here's the code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("DCNTemp").Select
Range("AZ2").Select
ActiveCell.Value = ActiveCell.Value + 1
Range("a1").Select
ActiveWorkbook.Save
Load SignIn
SignIn.Show
End Sub