ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting paste function to list all addin functions (https://www.excelbanter.com/excel-programming/380432-getting-paste-function-list-all-addin-functions.html)

scotty[_2_]

getting paste function to list all addin functions
 
I am trying to work out why the paste function wizard does not list all
the functions from my addins (done using registerxll). I do have many
100s of functions in the addins.

Hence, I am guessing there is some max list size, does anyone know what
it is?

Using excel 2000. Would be interested to know if the list size changes
with 2003.

Also, are there any workarounds to this issue people know of? Can I
somewhere change the list size, might it be some reg setting?


scotty[_2_]

getting paste function to list all addin functions
 

there is definitely a max list size, since as i change the order of
addins, i see functions disappearing from the wizard as it hits its
limit.


scotty[_2_]

getting paste function to list all addin functions
 

v2000 for sure has a much smaller limit, i am thinking 1024. very
irritating. hopefully some easy fix...if not, i'll need to code
something up that can do this.



All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com