Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MacroOptions Question

Status
Not open for further replies.

N1GHTEYES

Technical User
Jun 18, 2004
771
GB
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?
 
The way of adding descriptions to UDF (category, argument description) can be found here (Laurent Longre website): You can try to export the module, it can show the way excel handles descriptions when viewed with text editor.

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

Part and Inventory Search

Sponsor

Back
Top