No offense to Mike Alexander.
I had an Excel workbook with 1000+ sheet- and workbook-level names, and needed to delete them. I tried doing it using Excel's existing functionality (big mistake). Then I remembered the free Name Manager add-in that everybody talks about.
Believe it or not, I almost never use add-ins. My Outlook is add-in-free; I use macros and/or rules to move emails around. I do use the Analysis Toolpak in Excel from time to time, and I use my Amazon ad link generator every so often to create affiliate links for this site. I also use JMT Utilities from time to time (mostly to play games, though). I've installed the Smart Indenter, Code Cleaner and the VB6/VBA mouse wheel fix, but I don't consider those to be "real" add-ins in the same sense as the Name Manager. I'm aware of the more popular add-ins and use them as needed. I end up downloading and using one, deleting it, then downloading it again later when I need it again.
The Name Manager was easy to install (just download and unzip the archive, open the Setup workbook and click the install button). Here's a screenshot of the main utility screen.
I love that the window is resizeable, and all the controls move around to accomodate the adjustment. One thing I would like to see, however, is the ability to use the mouse wheel to scroll through the main listbox. That way I could click one name, scroll down and Shift+Click to select a block of names without having to use the scrollbar.
It did save me a few hours of extremely tedious work, so if you need to work with range names, download it. It's free!
About JP
3 Comments:
You mentioned using rules to move emails around, is it possible to set up a rule that forwards ALL emails that hit your Outlook to an external account such as Hotmail or Google??? Thanks
Sure. If you wanted to use VBA, you could adapt the technique found here:
Event Code for Forwarding Selected Text to Another Email Address
If you wanted to use Rules, see Automatically forward messages to another e-mail account
Excellent, thanks for your help