startup date point

B

BorisS

I'd like for my project (which goes back to October '04) to start upon open
with the current day (or at least some place that I can update every now and
then with which date I'd like the view to start at0 as the first thing it
shows me in my Gantt. But I'd also still like the whole project to be in my
list and viewable with the horizontal slider. Anyone know how to get the
default view for a project to start with a particular or "Today()" date?

Thx.
 
J

John

BorisS said:
I'd like for my project (which goes back to October '04) to start upon open
with the current day (or at least some place that I can update every now and
then with which date I'd like the view to start at0 as the first thing it
shows me in my Gantt. But I'd also still like the whole project to be in my
list and viewable with the horizontal slider. Anyone know how to get the
default view for a project to start with a particular or "Today()" date?

Thx.

Boris,
What I understand you want could be accomplished several ways. One
method might be to create an Open Event macro that initializes the view
to the current date. But here's a simple method that doesn't require
VBA. First, create a dummy task at or near the top of the file. Use a
spare date field as a custom field with the formula,
Date1 = [current date]
(Note: be aware that the current date will appear in the Date1 field for
all tasks except Summary Lines, unless you elect to roll up. This
doesn't affect anything, it just means that the Date1 field cannot be
used for anything else.)
Now do a "copy" of the Date1 field on the dummy task. Next select the
Start field of the dummy task and go to Edit/Paste Special. Select Paste
Link and hit "ok". The Start date of the dummy task will now track the
current date. As soon as you open the file select the dummy task and use
the "go to selected task" icon on the Standard toolbar.

The method is a little crude but it does work.

Hope this helps.
John
Project MVP
 
B

BorisS

this is the kind of tricking of Office products that I love. Works great.
Thanks so much.
--
Boris


John said:
BorisS said:
I'd like for my project (which goes back to October '04) to start upon open
with the current day (or at least some place that I can update every now and
then with which date I'd like the view to start at0 as the first thing it
shows me in my Gantt. But I'd also still like the whole project to be in my
list and viewable with the horizontal slider. Anyone know how to get the
default view for a project to start with a particular or "Today()" date?

Thx.

Boris,
What I understand you want could be accomplished several ways. One
method might be to create an Open Event macro that initializes the view
to the current date. But here's a simple method that doesn't require
VBA. First, create a dummy task at or near the top of the file. Use a
spare date field as a custom field with the formula,
Date1 = [current date]
(Note: be aware that the current date will appear in the Date1 field for
all tasks except Summary Lines, unless you elect to roll up. This
doesn't affect anything, it just means that the Date1 field cannot be
used for anything else.)
Now do a "copy" of the Date1 field on the dummy task. Next select the
Start field of the dummy task and go to Edit/Paste Special. Select Paste
Link and hit "ok". The Start date of the dummy task will now track the
current date. As soon as you open the file select the dummy task and use
the "go to selected task" icon on the Standard toolbar.

The method is a little crude but it does work.

Hope this helps.
John
Project MVP
 

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