Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically,
Office 2010 Key, their mouse scroll wheel (or equivalent) does not work in the code window. I just noticed in recent builds of
Office 2007 that it does. I am not sure when,
Windows 7 32 Bit, exactly, that was fixed, but I am happy to report that it has been, so there you go.Additionally, I sort of blew it in the last post when I didn’t include any screenshots of a PivotTable with Page Fields (or “Report Filters” as we are calling them in Excel 2007). Since they look sharp,
Windows 7 32 Bit, I wanted to redress that. Here are 4 of the PivotTables I showed you last time with Report Filters added. Note that they have lost that “button” look and are now nicely formatted text.
(Click to enlarge)While I was at it,
Microsoft Office Pro Plus, I thought I would include a shot of multi-select in PivotTable Report Filters. In this case,
Office 2007 Ultimate, the PivotTable is bound to an OLAP cube, so there is dimensionality to what can be filtered.
<div