The site formerly known as Code For Excel and Outlook
February 3, 2010 by · 
In the previous post I showed a simple sub for listing most of the CommandBar properties. But we can also return this information using a function.
You might do this (in Excel versions prior to 2007) when working with a command bar and need to view its properties before making a change. Here is a function that returns a string array of properties for each Command Bar Object.
Continue Reading: Return Command bar info in a VBA function »
February 1, 2010 by · If you work with Command Bars in Excel, or write add-ins for Excel 2003 that add custom menu options, you'll need to know various properties such as their names. A basic subroutine would look like this:
Continue Reading: List all Command Bar Properties in Excel »
January 4, 2010 by · 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.
Continue Reading: The JKP Name Manager just saved my bacon »
Site last updated: February 8, 2012
Follow Me