Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good morning,
Found this macro and it seems ok, but it doesn't work. So created a new module for that and added this to the module. Sheet name is correct, so what am I missing here?
Thank you for your time,
Romano
Private Sub Workbook_Open()
' Erase cells on open workbook
Application.EnableEvents = False
Worksheets("A100").Range("a2:a4").Clear
Application.EnableEvents = True
End Sub
Found this macro and it seems ok, but it doesn't work. So created a new module for that and added this to the module. Sheet name is correct, so what am I missing here?
Thank you for your time,
Romano
Private Sub Workbook_Open()
' Erase cells on open workbook
Application.EnableEvents = False
Worksheets("A100").Range("a2:a4").Clear
Application.EnableEvents = True
End Sub