MS Project Client Only: Save a new global.mpt and distribute to your peers with intructions to replace their own global Careful! This will remove any of their own customizations (uncommon).ġ0 Free Code!!! Go to Go to Recordings and add the “VBA Macros and Toolbars” to your cart. Simple: Add the code module and views/macro buttons to the enterprise global. Sub ResourceAllocationWithGraph() ViewApply Name:="2c - Resource Allocation with Graph" SelectSheet OutlineHideSubTasks Sort Key1:="Start", Renumber:=False SelectResourceField row:=0, Column:="Name" GotoTaskDates End Subĩ Deploying the Code Project Server MS Project Client Only: ViewApply Name:="0b - Build Gantt Split" WindowActivate TopPane:=False ViewShowResourcesPredecessors End Sub GroupApply Name:="No Group" OutlineShowAllTasks End Subħ Custom View Macro Sub M圜ustomGantt() PaneClose
Sub JumpToMPUG() FollowHyperlink (" CommandBars("Web").Visible = False End SubĦ Reset the Filters Sub ResetAllFilters() Filt erApply Name:="All Tasks" Use the object browser if needed to find out functions/objects Customize the ribbon/toolbar to add the new macro to a button. The module will hold all your future macros.) Add the code. Open project and go to the Visual Basic View (Alt-F11) Click INSERT – MODULE (1st time only. Highlight Filters Link to IT MSPS Help Quick look at tasks in the next 2 weeks View Gantt by ww, Qtr, Month, or Days Show Progress Lines Baseline Project Shortcut Quick menu to custom Filters Reset all filters & groups Assign team resources Process Web Updates Quick menu to custom views Quick menu to custom Groups Update team vacations Publish Project to Reports Perform Custom Functions/Automate Routine Tasksģ Enhanced Toolbars Filter on dependent tasks for any selected task
Phoenix Using VBA Macros on MS Project Spencer Lamoreaux Chapter Monthly Meeting March 9th, 2010Ģ Why use VBA? Create custom toolbars Generate special reports Presentation on theme: "Using VBA Macros on MS Project"- Presentation transcript:
0 kommentar(er)
