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 […]

Read More

Speedup Excel VBA Macros with Protect UserInterFaceOnly

Excel , VBA

Many Excel macros run on protected worksheets. If you use the little piece of VBA code in this article they will run a lot faster. Let me give you an example. I just finished a very robust Return on Investment calculator that has seven sheets of data entry, revenue forecasts, and output reports. It uses […]

Read More

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 […]

Read More