MacroOptions Question

[N1GHTEYES]

Thanks to Combo, I know I can use the Application.MacroOptions method to set descriptions for UDFs. I also decided to start putting my UDFs in a particular add-in into specific (new) categories, using the string option with the Category named variable. Fine, that works great in office 2003. BUT, when I run it in Office 2000, it throws an error.

The 2003 help gives much more (than 2000) on the Category keyword, defining it (optionally) as String as well as the standard integer definition. Now maybe this is just a case of MS telling us about functionality which has always been there, but not previously spelt out, or maybe 2003 has added new functionality. BUT, even though the macrooptions method does not work under 2000 to define new categories in the same way 2003 does, nevertheless when I ran the Macrooptions category-defining code on the add-in in 2003, then saved it and opened it in 2000, the new categories were there. So, there must be some way for 2000 to store and recognise new categories for UDFs.

My question is, does anyone know where, how, if it can be accessed, and, if so, how?

 

[combo]

The way of adding descriptions to UDF (category, argument description) can be found here (Laurent Longre website):

http://xcell05.free.fr/index.html.

You can try to export the module, it can show the way excel handles descriptions when viewed with text editor.

combo

 

[N1GHTEYES]

Thanks combo. I'll investigate when I get a few free nanoseconds, but it looks, from a first glance, like what I was after.