M
Mark Durrenberger
I have virtually the same code as documented here...
http://msdn.microsoft.com/library/en-us/PR2KSDK/html/automatemp2k.asp
Private Sub App_ProjectBeforeChange(ByVal asg As Assignment,
ByVal Field As PjAssignmentField, ByVal NewVal As Variant, Cancel As
Boolean)
If Field = pjTaskText20 Then
MsgBox "You cannot edit this field", vbOkOnly
Cancel = True
End If
End Sub
I am trying to prevent a user from changing data in pjTaskText20. (It's a
"calculated" value).
So, I try to change a value in a cell,
the message box comes up says Nope can't do that
I dismiss the msgbox
so far so good
Now I try to move to another cell (say an arrow key) but I get stuck in the
"no change" event and can't move my cursor out of the active cell until I
press the escape key. Is this normal? Is there a way to break out of the
change code without hitting the escape key???
Thanks,
Mark
--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________
The nicest thing about NOT planning is
that failure comes as a complete surprise and is not
preceded by a period of worry and depression.
- Sir John Harvey-Jones
http://msdn.microsoft.com/library/en-us/PR2KSDK/html/automatemp2k.asp
Private Sub App_ProjectBeforeChange(ByVal asg As Assignment,
ByVal Field As PjAssignmentField, ByVal NewVal As Variant, Cancel As
Boolean)
If Field = pjTaskText20 Then
MsgBox "You cannot edit this field", vbOkOnly
Cancel = True
End If
End Sub
I am trying to prevent a user from changing data in pjTaskText20. (It's a
"calculated" value).
So, I try to change a value in a cell,
the message box comes up says Nope can't do that
I dismiss the msgbox
so far so good
Now I try to move to another cell (say an arrow key) but I get stuck in the
"no change" event and can't move my cursor out of the active cell until I
press the escape key. Is this normal? Is there a way to break out of the
change code without hitting the escape key???
Thanks,
Mark
--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________
The nicest thing about NOT planning is
that failure comes as a complete surprise and is not
preceded by a period of worry and depression.
- Sir John Harvey-Jones