Developer: If you write code or create forms and applications for Excel, this is your tab. It also includes macro handling, so power users might also want to visit here every once in a while.

Your Excel formulas cheat sheet: 22 tips for calculations and common tasks. Max Productivity ... especially if you’re editing a macro or tracking down a circular reference.

This macro will even unhide sheets you hide via the Visual Basic Editor properties (xlSheetVeryHidden) so be careful how you apply it. To run the macro, click Macros in the Code group on the ...