J
JohnJ
Hello all,
Is it possible to identify when a user clicks on a cell or column on a table
in Word? I can identify when a user tabs into a cell using:
Dim CurrentColumn As Long
Selection.MoveLeft
CurrentColumn = Selection.Information(wdStartOfRangeColumnNumber)
If CurrentColumn = 1 Then
MsgBox "Text in this column should not be amended", vbExclamation, " LR
Correspondence"
Selection.SelectCell
Selection.MoveLeft unit:=wdCharacter
End If
But I would like the same message to appear if a user clicks on a cell.
Taking it a stage further, I would like it to appear if a user clicks on
pspecific text. I am working on this thorny problem at the moment, if I have
any success then I shall post the answer.
In the meantime if you can provide any ideas, to speed this investigation up
then that would be great.
Thank you.
Is it possible to identify when a user clicks on a cell or column on a table
in Word? I can identify when a user tabs into a cell using:
Dim CurrentColumn As Long
Selection.MoveLeft
CurrentColumn = Selection.Information(wdStartOfRangeColumnNumber)
If CurrentColumn = 1 Then
MsgBox "Text in this column should not be amended", vbExclamation, " LR
Correspondence"
Selection.SelectCell
Selection.MoveLeft unit:=wdCharacter
End If
But I would like the same message to appear if a user clicks on a cell.
Taking it a stage further, I would like it to appear if a user clicks on
pspecific text. I am working on this thorny problem at the moment, if I have
any success then I shall post the answer.
In the meantime if you can provide any ideas, to speed this investigation up
then that would be great.
Thank you.