Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Run an Excel Macro From a Cell Reference

Last week I wrote an article about hiding Excel macros, so they don’t appear in the macro list. While working on that article I noticed that the Macro dialog box has a Collapse Dialog button.
While the Macro name box is active, you can go to the workbook, select a sheet, and click on a cell.
[...]