Preventing registered functions from showing on 2k7 autocomplete.

[lab27]

Hi All,

Anyone know if it's possible to prevent functions registered with the
XLL interface from showing up in the autocomplete list?

I've done a little digging, and any /VBA/ function which is postfixed
with a '_' isn't displayed, (nor is it shown in the function wizard).
(This isn't the case for XLL addin functions though).

Also, if an XLL addin function is registered with the function name
(pxFunctionText, so nothing to do with pxTypeText) postfixed with a
question mark '?', it is not shown in the function wizard - however it
is still shown in the autocomplete list (!).

Interestingly, I've failed to find a documented description of either
of these behaviours.... (_ or ? postfixing)

That being said, anyone have a sensible way of hiding functions from
the autocompletion list?

(Fwiw, this is in order to continue to register functions for
deprecated addin functionality, but to make them less 'visible' to the
user).

Cheers,

Lee.

[lab27]

Amusing (and I'm pretty sure undocumented) fact encountered when I did
a little digging on this -

(also relevant to an ancient question I asked, so it's nice to get
closure http://groups.google.co.uk/group/microsoft.public.excel.sdk/browse_thread/thread/a20967c39fd2108e/a78d25cdbe75b526?q=
:) )

Not that it stops the functions from being shown, but it turns out the
lexeme for an XLL udf (discounting unicode) is

[a-zA-Z_.\\?][a-zA-Z_.\\?0-9]+

So if you reeeeally want, you can register "a\._??\._3".

Got to wonder what the use of that is ;)

Lee.