How To: Display Pivot Table methods and properties in VBA intellisense

When you are coding and use a compact method of referring to a pivot table such as: ActiveSheet.PivotTables(1). You would expect VBA’s intellisense to display the methods and properties of the PivotTables collection when adding the period, however in Excel 2007 and 2010 you get no intellisense whatsoever. There is a workaround for displaying these methods and…