Re: start up macro

From: John Skipton (anonymous_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 08:50:33 -0700

I can't send the file due to company confidentiality etc,
however I have just tested the macro on a blank file and
it works ok. The file I am using is a file with several
linked projects embedded in it - would this make a
difference?

Rgds

John

>-----Original Message-----
>It should fire when you open that file.
>If it doesn't can you send me the file?
>
>OBTW you don't have a high virus protection in your
Project Options have
>you?
>
>Jan De Messemaeker
>Microsoft Project Most Valuable Professional
>http://users.online.be/prom-ade/index.htm
>32-495-300 620
>"John Skipton" <anonymous@discussions.microsoft.com>
schreef in bericht
>news:1cad01c485cf$8f523370$a301280a@phx.gbl...
>> thanks, it doesn't do anything though.
>>
>> I have literally just pasted the two lines you mentioned
>> so that the code looks like:-
>>
>> Private Sub Project_Open(ByVal pj As Project)
>> ViewApply "Gantt Chart"
>> FilterApply "Remaining WG & SG Milestones"
>> End Sub
>>
>> Is there anything else I should add?
>>
>> Rgds
>>
>> John
>>
>> >-----Original Message-----
>> >Hi,
>> >
>> >Open the file
>> >Alt+F11
>> >In the leftmost window under VBAProject
>> (nameofyourprojecyt) find
>> >ThisProject, double-click
>> >The window thisproject(code) pops up
>> >Upper left select Project
>> >
>> >Code appears:
>> >
>> >Private Sub Project_Open(ByVal pj As Project)
>> >
>> >End Sub
>> >
>> >Between the two write the macro, for instance
>> >
>> >Viewapply "Gantt Chart"
>> >Filterapply "Thisfilter"
>> >
>> >
>> >HTH
>> >
>> >--
>> >Jan De Messemaeker
>> >Microsoft Project Most Valuable Professional
>> >http://users.online.be/prom-ade/index.htm
>> >32-495-300 620
>> >"John Skipton" <anonymous@discussions.microsoft.com>
>> schreef in bericht
>> >news:05c501c4845f$613f3b70$a301280a@phx.gbl...
>> >> I want a filter to be automatically applied as soon
as a
>> >> project file is opened. I assume the best way to do
this
>> >> is to record a macro that applies the filter and for
>> that
>> >> macro to be started when the file opens. How do I set
>> this
>> >> up??
>> >>
>> >> Rgds
>> >>
>> >> John
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages