Category Archives for "VBA"

Show or Hide Data and Charts with Dynamic Excel Reports

Excel , Reporting , VBA

With a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected sales regions or to expand a table to show […]

Continue reading

Adding the Developer Tab to the Excel Ribbon

Excel , VBA

Reading this will teach you one of the secret incantations need to move from mid-level Excel user to Excel power user. Hidden to the eyes of novice and mid-level Excel users is the Developer tab. It holds tools that give you extra Excel power – the power to add check boxes to turn IF statements […]

Continue reading