Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA script for recognising MS Project View

Status
Not open for further replies.

cberry02

Computer
Mar 18, 2008
1
Hi,

I'm trying to get a macro to determine whether or not a Tracking Gantt is currently showing, and if it is, to apply certain changes to the Gantt Bar Style. The reason I need the script to recognise whether or not a Tracking Gantt is currently showing is that if a different view is showing this gantt bar style edit produces an error.

Does anyone know a for or if loop which identifies the current view of the active project?

Thanks,
Chris
 
Replies continue below

Recommended for you

Here are a couple:

Private Function ActiveViewOfActiveProject() As ViewSingle
Set ActiveView = ActiveWindow.ActivePane.View
End Function

Private Function ActiveView(TargetProject As Project) As ViewSingle
Set ActiveView = TargetProject.Windows.ActiveWindow.ActivePane.View
End Function

Hope this helps.
KW
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor