ProjectBeforeChange event question

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top