sharpcells
New Member
- Joined
- Nov 15, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi all,
I have discovered a technique for monitoring Excel's edit mode that appears to be previously undocumented. I am in the process of applying it to the add-in I am developing but have produced a blog post to describe the solution.
The essence is to make calls to the
Hope this is helpful for others.
I have discovered a technique for monitoring Excel's edit mode that appears to be previously undocumented. I am in the process of applying it to the add-in I am developing but have produced a blog post to describe the solution.
The essence is to make calls to the
LPenHelper
function in XLCALL32.DLL and inspect the returned type to determine the current edit mode. Has anyone else made use of this function before?Hope this is helpful for others.