View original (French)

ConvNumberLetter function

Solved
CECO_6776 Posted messages 5 Status Membre -  
 DAVIDO -
Hello,

Please let me know how to make the ConvNumberLetter function appear in the list of Excel functions every time I open an Excel file?

Best regards

Configuration: Windows / Chrome 78.0.3904.70

2 réponses

Réponse 1 / 2
ALS35 Posted messages 1034 Registration date   Status Membre Last intervention   147
 
Hello,

You need to copy the module that contains it to the personal macro workbook, in the VBA window it's called PERSONAL.XLSB.
When you close Excel, save this personal macro workbook.

Best regards
0
CECO_6776 Posted messages 5 Status Membre
 
Thank you ALS35 for your response.

It works for the workbook I'm using, but when I open another workbook, I can no longer see this function. How can I make Excel remember it like the SUM function, for example?
Best regards.
0
ALS35 Posted messages 1034 Registration date   Status Membre Last intervention   147
 
Hello,

I told you, you need to put this function in the personal macro workbook (PERSONAL.XLSB).
How did you manage to put this function in your file?
Otherwise, open your Excel file, press Alt + F11, this opens the VBA editor, in the left window you should see a folder VBAProject (the name of your file) with a subfolder Modules where you should find a module containing your concerned function.
Do you also see a folder VBAProject (PERSONAL.XLSB)?

Best regards
0