| |
| Display AutoFilter Criteria
Posted in MS Excel > Macros by tutorialgrub on Dec 05, 2011
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied. |
| |
| Hide and Restore Toolbars in Excel
Posted in MS Excel > Macros by tutorialgrub on Dec 04, 2011
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings for other spreadsheets when yours is closed. |
| |
| Convert Formula References from Relative to Absolute
Posted in MS Excel > Macros by tutorialgrub on Nov 28, 2011
Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows. |
| |
| Prevent Case Sensitivity in VBA Code
Posted in MS Excel > Macros by tutorialgrub on Nov 28, 2011
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words. |
| |
| Excel Three-Criteria Limit for Conditional Formatting
Posted in MS Excel > Macros by tutorialgrub on Nov 22, 2011
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. |
| |
| Track and Report Changes in Excel
Posted in MS Excel > Macros by tutorialgrub on Nov 16, 2011
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature. |
| |
| Force Text to Upper- or Proper Case
Posted in MS Excel > Macros by tutorialgrub on Nov 15, 2011
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only. |
| |
| Retrieve a Workbook Name and Path
Posted in MS Excel > Macros by tutorialgrub on Nov 14, 2011
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. |
| |
| Run Procedures on Protected Worksheets
Posted in MS Excel > Macros by tutorialgrub on Nov 05, 2011
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. Avoid that problem with the following tutorial. |
| |
| Change Text to Upper- or Proper Case
Posted in MS Excel > Macros by tutorialgrub on Nov 05, 2011
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case. |
1 2 3 >> Next |
