MDMi Productivity Excel Toolbar
If you use Excel as much as we do, you learn quickly that some tasks can be repetitive and downright annoying (imagine un-hiding 50+ worksheets one at a time). For years we have been finding better ways to use Excel using VBA scripts to eliminate the pain of many annoying tasks. We accumulated more than 20 scripts that we had never released for use outside MDMi. Well, now we are making these available to our customers via a Toolbar plugin for Excel. Check out the MDMi Productivity Excel Toolbar.
Currently there are 25 tools available in the toolbar. They include tools for tasks such as:
- Naming Ranges
- Validating Data
- Workbook and Worksheet Visibility and Protection
- File Optimization
- Materials Database Importer Template Checking
Each download includes all the same tools we use at Materials Data Management! Our team has saved hundreds of hours and much frustration by using these tools.
We’re also encouraging others to tell us their pain points. If we find it painful enough we’ll see if we can find a better way! If you have your own scripts you’ve written let us know.