From: Norman Harker (njharker_at_optusnet.com.au)
Date: Mon, 29 Mar 2004 10:38:32 +1000
And now a question.
I've found that I can use the Sheet on an addin to call my functions
in upper case and thus force conversion of entry to upper case.
How can I best achieve this for an existing Addin?
-- Regards Norman Harker MVP (Excel) Sydney, Australia firstname.lastname@example.org Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Norman Harker" <email@example.com> wrote in message news:%23Ugw34MFEHA.1272@TK2MSFTNGP12.phx.gbl... > Hi Hans! > > Prevention better than cure? > > Close Excel > Re-Open > Put the function in your Personal.xls file > Unhide the Personal.xls > Use the function in upper case in the Personal.xls file > Hide the Personal.xls > > Now try and use your function using lower case. > > Or: > Close Excel > Open Excel > Put the function in a separate file > In the (compulsory) empty sheet use the function with upper case > Save as an Addin in the Library File > Close Excel > Open Excel > Tools > Addins > Select your new Addin > Try using the new function without using upper case > > > Thanks for this post! We now have a way of getting UDFs to convert to > all upper case if entered in lower case. John Walkenbach (I recall) > recommends using lower case entry of functions as failure to convert > to uppercase indicates a mis-speling. > > -- > Regards > Norman Harker MVP (Excel) > Sydney, Australia > firstname.lastname@example.org > Excel and Word Function Lists (Classifications, Syntax and Arguments) > available free to good homes. > "Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> wrote in message > news:%23P68ciIFEHA.3856@TK2MSFTNGP12.phx.gbl... > > Thank you to all who replied. > > Should I add that shortly after I posted my message I tried the > following which also worked: > > > > 1. Changed the code so that all instances of EF temporarily were > named EFF. > > 2. Used the function EFF one time in a worksheet. > > 3. Changed the code back (EFF replaced by EF) > > 4. Used the function EF in a worksheet, remembering to enter EF > (uppercase) the first time. > > > > Regards > > Hans Knudsen > > > > > > > > "Hans Knudsen" <hans.knudsen__REMOVE__@mail.tele.dk> skrev i en > meddelelse news:uGQtQl9EEHA.3336@TK2MSFTNGP12.phx.gbl... > > > Hello > > > I made a UDF and wanted to name it EF (uppercase). However, first > time I entered the function, I happened by mistake to enter ef > > > (lowercase). Is there any way I can change it back to uppercase? > > > > > > Hans Knudsen > > > > > > > > > > > >