Re: start up macro
From: Jan De Messemaeker (jandemes)
Date: 08/19/04
- Next message: Steve House: "Re: GANTT CHART - Baseline and Actuals"
- Previous message: John Skipton: "Re: start up macro"
- In reply to: John Skipton: "Re: start up macro"
- Next in thread: John Skipton: "Re: start up macro"
- Reply: John Skipton: "Re: start up macro"
- Reply: John Skipton: "Re: start up macro"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Aug 2004 11:56:50 +0200
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
> >
> >
> >.
> >
- Next message: Steve House: "Re: GANTT CHART - Baseline and Actuals"
- Previous message: John Skipton: "Re: start up macro"
- In reply to: John Skipton: "Re: start up macro"
- Next in thread: John Skipton: "Re: start up macro"
- Reply: John Skipton: "Re: start up macro"
- Reply: John Skipton: "Re: start up macro"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
