List all Functions

  • Thread starter Thread starter James
  • Start date Start date
J

James

Is there anyway you can list all the installed functions
in a spreadsheet?
 
A possible alternate interpretation:

by installed, do you mean functions used in the worksheet.

If so, you can loop through them (the cells with formulas) and parse out a
list, but there is not built in menu item to do it.

Regards,
Tom Ogilvy
 
Maybe I should explain a bit more

basically I want to send a spreadsheet to various users
in different countries that aren't networked that checks
the users system and reports back via e-mail what
functions they have installed.

All done except for actually getting the list of
functions the user has installed.

It has to be a list of functions and not addins.

Thanks for the previous replies.

James
 
Still not sure -
you mean go through their installed addins and see what functions those
addins contain?

Regards,
Tom Ogilvy
 
This is what I was hoping to do, probably not possible,
but just wondering.
 
Even in a workbook, you would have to use the VBE object model to search
through the modules line by line and look for SUB and FUNCTION. So I don't
think the information is made available by Excel and most addins are
probably password protected for their code.

Regards,
Tom Ogilvy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function created in VBA not listed in worksheet existing functions.Pleae Help 3
Open Specific Worksheet Using Button Form Control in Excel 0
LOOKUP function help 2
Counting multiple memberships 1
List of Financial functions 6
Copy formula amongst files but create cross-link problem 2
Combine 2 columns in a dynamic range into one 7
Help file for VBA custom function 2

Back
Top