How to allow Excel uppercase characters only

How to allow Excel uppercase characters only

It’s often a good idea to use Data Validation feature to limit user errors and streamline data entry process. In addition to built-in rules, like size of a number or length of a text, you can define your own rules in a Custom fashion. Let us show you how to allow...
How to prevent Save As with VBA

How to prevent Save As with VBA

This article shows you How to prevent Save As with VBA. You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...
How to create an Excel histogram

How to create an Excel histogram

A histogram is a visual representation of the distribution of numerical data. Grouping data into specific percentiles can give you a better overview of the big picture. You can create an Excel histogram in two ways: Using formulas Analysis ToolPak add-in   Excel...