Password-Protect a Worksheet from Viewing
Keep prying eyes from viewing a worksheet, unless they have the password. Read more...
MS-Excel - General Formatting Tutorials
Sort Worksheets
One of the most commonly used functions in Excel, sorting is usually performed on a list, table, or range of cells, but you can take things a step further and sort your worksheets as well. Read more...
Name a Workbook with the Text in a Cell
It's quite common for Excel users to want to save an Excel file with a filename that corresponds to the text in a worksheet cell. This can be done with the help of a small amount of code inserted into a module. Read more...
Find a Number Between Two Numbers
Enhance Excel's Find feature to search for the first occurrence of a number that falls between two specified numbers. Read more...
Create a List of Workbook Hyperlinks
Use a bit of Excel VBA macro code to create a list of hyperlinked Excel workbook names on any Excel worksheet. Read more...
Automatically Add Date/Time to a Cell upon Entry
Enter a static date, or date and time, into a corresponding cell after data is entered into other cells. Read more...
Distribute Macros
Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go. Read more...
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Read more...
Excel's Three-Criteria Limit for Conditional Formatting
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria. Read more...
Retrieve a Workbook's Name and Path
Every now and then you might want a cell to return the name of a workbook, or even the workbook's filename and path. With this tutorial, it's easy to retrieve a workbook's name and path. Read more...