craigexcel
Active Member
- Joined
- Jun 28, 2006
- Messages
- 295
- Office Version
- 2016
- Platform
- Windows
What is the VB for capturing the existing setting of OnEntry, when a user opens a workbook?
I'd like to reset the variable to its pre-existing setting when the user closes the workbook.
e.g.: Application.OnEntry = ""
I'd like to reset the variable to its pre-existing setting when the user closes the workbook.
e.g.: Application.OnEntry = ""