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 »