streetprog
Technical User
I've tried searching through the EXTRA library for this, but haven't found what I'm looking for. Is there a way for EXTRA to return the field type of the current cursor position. In the Settings - Colors, you can see the names of these fields: UnprotectedNormal, UnprotectedHigh, ProtectedNormal, ProtectedHigh.
What I'm aiming at is if the user has their cursor in a Protected field and tries to run the macro and the .SendKeys is used, it will pop up a msgbox and exit sub. Otherwise, it will lock up their session with the little man next to the X (maybe that is the ...OIA.XStatus = 3 aka xPROTECTED_FIELD).
That cursor position may be protected at times and unprotected at times so I can't rely on just where the cursor is. Thanks!
What I'm aiming at is if the user has their cursor in a Protected field and tries to run the macro and the .SendKeys is used, it will pop up a msgbox and exit sub. Otherwise, it will lock up their session with the little man next to the X (maybe that is the ...OIA.XStatus = 3 aka xPROTECTED_FIELD).
That cursor position may be protected at times and unprotected at times so I can't rely on just where the cursor is. Thanks!