Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically,
Genuine Office 2010, 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, exactly, that was fixed,
Microsoft Office Professional Plus 2007, but I am happy to report that it has been,
Office 2010 Home And Student Key, so there you go.Additionally,
Microsoft Office 2010 Professional, 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, 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, I thought I would include a shot of multi-select in PivotTable Report Filters. In this case,
Windows 7 Pro Product Key, the PivotTable is bound to an OLAP cube, so there is dimensionality to what can be filtered.
<div