Recently Received a query from user, at times users open plan from server without noticing that plan is already checked out, hence ending up opening plan in read only mode (though the open dialog box itself displays the project check in state and whom it is checked out to, but doesn’t displays any warning in form of pop up or message box ), hence they make all the changes without realizing untill they try to save the plan 😦
So here is a quick n easy solution by which you can explicitly notify users, in case they open plan in read only mode,
place the macro given below in global file, which would fire on Project Open event and would notify users just in case plan has been opened up in read only mode, thereby saving hours of planning effort 🙂
Sub TestProjectReadOnlyState()
If ActiveProject.ReadOnly = True Then
MsgBox (“Project has been opened in Readonly mode, changes made will not be saved”)
End If
End Sub
Good idea and easy way out to save Project Planning Hours for Project Managers in case of ignorance of the Checked Out state.
where this query has to be executed? or is that a stored procedure to be written in DB Table ?
This is a Macro, that needs to be embedded In Enterprise Global in MS Project 🙂