TutorialGrub.com Desktop Applications tutorials. http://www.tutorialgrub.com Use a custom function to display the criteria used for any column in a table with an AutoFilter applied. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Display-AutoFilter-Criteria_19233.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Display-AutoFilter-Criteria_19233.html Mon, 05 Dec 2011 21:00:01 CST 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. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Hide-and-Restore-Toolbars-in-Excel_19278.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Hide-and-Restore-Toolbars-in-Excel_19278.html Sun, 04 Dec 2011 12:00:01 CST Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Convert-Formula-References-from-Relative-to-Absolute_19205.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Convert-Formula-References-from-Relative-to-Absolute_19205.html Mon, 28 Nov 2011 14:00:01 CST 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. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Prevent-Case-Sensitivity-in-VBA-Code_19194.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Prevent-Case-Sensitivity-in-VBA-Code_19194.html Mon, 28 Nov 2011 07:00:01 CST 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 u http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Excel-ThreeCriteria-Limit-for-Conditional-Formatting_19195.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Excel-ThreeCriteria-Limit-for-Conditional-Formatting_19195.html Tue, 22 Nov 2011 07:00:11 CST To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Track-and-Report-Changes-in-Excel_19243.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Track-and-Report-Changes-in-Excel_19243.html Wed, 16 Nov 2011 02:00:02 CST Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Force-Text-to-Upper-or-Proper-Case_19199.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Force-Text-to-Upper-or-Proper-Case_19199.html Tue, 15 Nov 2011 05:00:05 CST 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 http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Retrieve-a-Workbook-Name-and-Path_19281.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Retrieve-a-Workbook-Name-and-Path_19281.html Mon, 14 Nov 2011 06:00:02 CST 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 http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Run-Procedures-on-Protected-Worksheets_19225.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Run-Procedures-on-Protected-Worksheets_19225.html Sat, 05 Nov 2011 12:00:01 CDT 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. http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Change-Text-to-Upper-or-Proper-Case_19230.html http://www.tutorialgrub.com/tutorials/MS-Excel/Macros/Change-Text-to-Upper-or-Proper-Case_19230.html Sat, 05 Nov 2011 07:00:01 CDT