![]() ![]() I use Rob’s Chart Labeler and VBA Code Cleaner utilities. Microsoft Excel MVP and author Rob Bovey, of Application Professionals, offers a handful of free utilities. In this way, you can maintain an informal version history in the recycle bin, as well as track your activities. When a new copy is saved, the existing copy is removed to the recycle bin. If Excel shuts down improperly, AutoSafe offers to restore the files in use prior to the crash. AutoSafe saves a copy of your open workbooks in a directory you specify, without overwriting the workbooks. This utility can save a developer many hours.ĪutoSafe is what Microsoft was thinking when they implemented Autosave. Especially powerful is the ability to work on many Names at once. You can add and delete Names, and see what ranges they refer to. ![]() You can make Names hidden or visible, local to the worksheet or global to the workbook. You can view all names, or filter by a number of conditions. The Name Manager is a high-powered tool for working with all of the Names in your workbooks. Jan Karel has offered me a percentage of sales on these two utilities, but that won’t amount to much, because they are free. I use Jan Karel’s Name Manager and AutoSafe. He has a variety of utilities on his web site, JKP Application Development Services, as well as a diverse collection of articles and tutorials. Two of my favorite tools were developed by fellow Microsoft Excel MVP Jan Karel Pieterse. If you think I’ve left out an important utility, tell me about it in the comments. This is an incomplete list: there must be hundreds of worthy utilities written by dozens of developers, but these are the ones I have tried and kept. My favorite utilities lean toward developer tools, rather than worksheet productivity tools. My reliance on these utilities is as a developer of Excel applications, that is, solutions that combine add-ins, templates, and regular workbook to accomplish specific objectives within specific operating parameters. ![]() I’m sure everyone has their favorites, and here I’m going to talk about mine. Excel is a mighty powerful application, and yet, there are any number of utilities available to extend its capabilities. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |