londonparisrome
New Member
- Joined
- Aug 1, 2019
- Messages
- 25
I have an Excel hosted on my OneDrive that needs to be cleared on open and close. It has a drop-down of student names for parents to check status of their student's activities. I have entered the following code, but it is not clearing the student name.
Any suggestions?
VBA Code:
Private Sub Workbook_Open()
Application.EnableEvents = False
Worksheets("Status").Range("E5").Value = ""
Application.EnableEvents = True
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Worksheets("Status").Range("E5").Value = ""
End Sub
Any suggestions?