How to Create a Pareto Chart in Excel
Posted on November 20th, 2008 by Joseph Harris
Creating Pareto Charts
Archive for the ‘Excel Hints’ Category
Removing Macros from a Workbook
Posted on November 12th, 2008 by Joseph Harris
Q:
How do I remove all the macros from my workbook? I don’t want the “this workbook contains macros prompt” to appear anymore?
Thanks,
Rodge
A:
Rodge,
There are three things you can do to get rid of the macros message when you open the workbook.
Set the macro security setting to low.
Move all of your worksheets to another workbook.
Manually delete the [...]
Excel Data Validation
Posted on November 11th, 2008 by Joseph Harris
Data validation gives the Excel developer a way of dictating the type of information that can be entered in a worksheet. It is a versatile tool that can be used in many situations.
With data validation you can:
Provide users a list of options to choose from
Dictate the type or size of input
Create custom settings
I often use data validation when I [...]
Excel Add-ins - Installing and Using
Posted on November 1st, 2008 by Joseph Harris
Quick guide to installing and using Excel add-ins.
Playing with VBA in Excel, Without Knowing VBA!
Posted on October 27th, 2008 by Joseph Harris
Introduction to user defined functions and VBA in Excel.
Excel Version Differences
Posted on October 26th, 2008 by Joseph Harris
I try to make all of the advice I offer on this blog generic to all Excel versions. Sometimes it is useful to know some of the more important (or useful) differences. Below are some of the differences that I try to keep a mental note of:
2000
Digitally signed macros
Pivot Charts
User forms
VBA 6 introduced
2002
Colored worksheet tabs
Formula [...]