19,154 tutorials online
20 tutorials pending review
763 dead links removed





Desktop Applications Tutorials

Subcategories:
MS Excel, MS PowerPoint, MS Word, QuarkXPress


 

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.
192 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
172 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
182 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
161 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
149 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
211 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
165 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
173 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
166 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport 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.
187 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial


1  2  3  4  5  6  7  8  9  10  11  12  13  14  15    >>  Next