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