Macro - Date Time View default for all users option

[Harry]

I want to write a Macro that will allow the date and time default for a
particular application file for ALL users. Can someone please please
provide some assistance to me on this. Thanks so much.


Harry

 

[Jan De Messemaeker]

Hi,

Open the file
Alt+F11
Upper left under VBAProject(Nameofyourfile), Microsoft ProjectObjects, find
ThisProject(Nameofyourfile), double-click
A window comes up with two small windows on top
Left Select Project
Right select open
Between the upcoming lines Private Sub... and End Sub cod ethe following
line:
Application.optionsview dateformat:=pjdate_mm_dd_yy_hh_mmAM
Close the VB Editor, save the file.
HTH

 

[Harry]

Hi Jan,

I followed your directions but only the date appears in the start and finish
columns not date AND time. The date format still shows date only.

I saved, closed and reopened the file and the date only appears.

I entered in the VB editor between...between Private Sub Project_Open and
End Sub



Application.optionsview dateformat:=pjdate_mm_dd_yy_hh_mmAM

What am I doing wrong? Thank you

Harry