Pro-business Excel VBA Programming

Note: We are not going to discuss here the Consolidation function of Excel. The said function is used if you want to sum up multiple numbers...

This is the first part of our discussion on how to export data to Excel. We will start with the simplest one; how to transfer data from a fl...

I will give you a very simple Pareto chart example. Create a new workbook and enter exactly the same figures in the screen shot below: The w...

The Pareto Chart , also known as the Pareto Analysis, ABC Analysis, or 80-20 Analysis, is based on the principle of "the vital few and ...

Here is a simple way to make your Excel worksheet as a simple database. In our example, we will create a vendors table and we will use an Ex...

This is an improvement of my previous post. It always happens to me that whenever I put a password protection in my Excel/VBA program, I nee...

There are situations that you need to hide a customized menu or to make worksheets read only from certain users that need your Excel file fo...

I have to apologize that I put off the supposedly next password article for this one. I must discuss this one first because the next passwor...

In our 2 previous posts, Excel Password Protection Part 1 & Part 2 , we tackled 2 ways to protect your Excel spreadsheets. The first pa...