Disabling a column?

E

Ewok

Is is possible to have a column not hidden but locked/disabled?
I've been trying with VBA but can't seem to isolate the column as an
'object' so as to then simply set it to 'enable = false'.
Any help would be much appreciated, thanks in advance.
 
W

www.projectserver.cz

You can use even hanglers in VBA to make field read only
'define you own instance of Application object
Public WithEvents zApp As Application

Private Sub Project_Activate(ByVal pj As Project)
'MsgBox "proj activate"
On Error Resume Next
If (pj.Type = pjProjectTypeEnterpriseCheckedOut) Or (pj.Type =
pjProjectTypeEnterpriseReadOnly) Then
Set zApp = pj.Application
End If
End Sub




Private Sub zApp_ProjectBeforeTaskChange(ByVal tsk As Task, ByVal
Field As PjField, ByVal NewVal As Variant, Cancel As Boolean)
if pjField= ... then Cancel=true
end sub



http://msdn2.microsoft.com/en-us/library/bb209093.aspx
 

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