Custom Categories for UDF

[EEL1966]

I have made different functions and I would like to have them in four different custom categories by using the following:

Please Login or Register  to view this content.

It works, but when I close Excel and open it again the functions are either in the B-serie category or in the user_defined category. I have the made a macro in my personal with the code above and associated it to a button. When I run the macro I can see all four categories with functions in the correct categories however when I close and open excel once more the problem is still there. What do I do wrong?

This is my first post so if it is in the wrong place sorry in advance.

Best regards
EEL1966

[romperstomper]

You need to call that code from the Workbook_Open event (in the ThisWorkbook module) of your workbook so that it gets run automatically when the workbook opens.

[EEL1966]

Thank you for your reply.

I have tried it and it seems to work. I have placed the following macro in "ThisWorkbook".

Please Login or Register  to view this content.

However when I closes Excel I get the following question in a Yes/No/Cancel box:

Do you want to save the changes you have made to 'B4-70 19A.xlam'?

I have tried to get rid of the question with the following macro in "ThisWorkbook".

Please Login or Register  to view this content.

This does not work. How do I get rid of the question?

Best regards
EEL1966

[romperstomper]

Probably because you keep changing the IsAddin property.

Note: when posting code on the forum, you must use code tags, please. I've added them for you again as it's only your second post, but please learn to use them in future.

[EEL1966]

With regard to the code tag I will remember that, sorry.

I have to change the IsAddin property in the Workbook_Open, else I get an error in the macro. I found the following in this forum:

http://www.excelforum.com/excel-prog...-as-addin.html

I have to say that I just did the same in the Workbook_Close.

[romperstomper]

For an overall solution, you might want to have a look at this article by Jan Karel Pieterse.
For the specific question of removing the prompt, change this in the Open event:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[EEL1966]

Thank you for your help, this works.

I have changed according to your suggestion in the Workbook_Open and I do not use the Workbook_Close.

Once more thank you and have a nice weekend
EEL1966

[romperstomper]

Thanks - you too.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save