On May 22, 1:56 pm, "Chip Pearson" wrote:
The "modify procedure" menu item is in VB6 not in VBA. To make a property
the default, you need to export the module to a text file, edit some
Attributes (these are similar to compiler directives and will not appear in
the VBA editor), and the import the text file. Complete details are at
http://www.cpearson.com/excel/DefaultProperty.htm
After poking around some more I found some info on the Dictionary
object and in particular at your website
http://www.cpearson.com/excel/Collec...ctionaries.htm. It
looks like this object should be sufficient for my needs and it's a
more standard way to go.
Denis