Why don't UDFs capitalise properly when input on a worksheet?

[pinkfloydfan]

Just a little query. Say you have written a UDF called AddDate().
When you use it excel always seems to drop the capital letters so in
the worksheet/function bar it reads as "=adddate()".

Any reason why this is or how to force excel to write it "properly" ?

Thanks a lot
Lloyd

 

[Zack Barresse]

Hi there,

It will be 'remembered' when it is first input into an Excel instance. So
the first time it is entered/calculated will be the case sensitivity that it
uses in that instance of the application. So either type it the way you
want the first time, or, have it in a hidden sheet that is hidden, call it
by code, create an xll add-in, etc.