UDF does not show up in Autocomplete

  • Thread starter Thread starter Dom
  • Start date Start date
D

Dom

I wrote a function in VBE using excel 2007, saved the workbook
as .xlam, went through excel options to make it available. It works
fine, but it does not show up in the autocomplete list. That is, when
I type "=" in a cell to get a list of available functions, the UDF is
not there. Any ideas? Also, if I get the autocomplete working, how
do I get it to list the description and the args?
 
also,

Excel2007 in:
Click the "Office".
Click "Excel Options".
Select the Add-Ins menu.
Select "Excel Add-ins" in the menu "Manage" (bottom of the window).
Click on "Go".


Note:
When your workbooks use functions from a supplement, and should be
sent to other users, make sure that they also have the supplement.
Otherwise, Formulas placed in the spreadsheet will no longer operational
and will return an error value # NAME?.

isabelle


Le 2013-02-20 21:50, isabelle a écrit :
 
also,

Excel2007 in:
   Click the "Office".
   Click "Excel Options".
   Select the Add-Ins menu.
   Select "Excel Add-ins" in the menu "Manage" (bottom of the window)..
   Click on "Go".

Note:
   When your workbooks use functions from a supplement, and should be
sent to other users, make sure that they also have the supplement.
Otherwise, Formulas placed in the spreadsheet will no longer operational
and will return an error value # NAME?.

isabelle

Le 2013-02-20 21:50, isabelle a écrit :





- Show quoted text -
Click to expand...

Thanks, Isabelle, but neither post really solved my problem. I
already have the function on demand in my spreadsheets. Everything
works, but it does not pop up in my autocomplete list. I would like
to see it there, along with a brief description and the arguments,
because I know I will forget it otherwise. Oddly it does show up in
the function list when I hit the "fx" button.

Dom
 
Back
Top