ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listing macro categories (https://www.excelbanter.com/excel-programming/297579-listing-macro-categories.html)

mark

Listing macro categories
 
I want to be able to create custom function categories, so
my add-in functions don't all appear in "User defined".

I understand about creating the category and assigning
functions to it with MacroOptions, but this seems to
require the category number, not the name. If I have more
than one custom add-in loaded, and they are both creating
new categories, the number associated with a given
category is not constant, so functions end up in the wrong
listing.

Any ideas please??


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com