customizing worksheet functions

P

pgianessi

Hello everyone.

Does anyone know where the code of a worksheet function is?
I mean, for example, where in the file system is the file -and what is
its extension- that contains the definition of the SUM.IF() function?

Are worksheet function grouped in modules? Where are them? Can a user
add additional modules?

And, most of all, can a user in some way add other customized modules,
so that I can create a module MYFUNCTS.<EXT> with my own worksheet
functions and have them available by simply loading my module?

I know this question is a little bit weird.. thanks to anyone who will
answer me.

Bye
 
N

Niek Otten

Answer to your last question:

http://office.microsoft.com/en-us/assistance/HA011117011033.aspx?mode=print

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello everyone.
|
| Does anyone know where the code of a worksheet function is?
| I mean, for example, where in the file system is the file -and what is
| its extension- that contains the definition of the SUM.IF() function?
|
| Are worksheet function grouped in modules? Where are them? Can a user
| add additional modules?
|
| And, most of all, can a user in some way add other customized modules,
| so that I can create a module MYFUNCTS.<EXT> with my own worksheet
| functions and have them available by simply loading my module?
|
| I know this question is a little bit weird.. thanks to anyone who will
| answer me.
|
| Bye
|
 

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

customizing worksheet functions 1
Functions - visibility 3
Conditional Sum across WORKSHEET 6
Please help me choose a product for the task 2
Customizing tab order 4
#Adding new worksheet problem 2
Create UDF in Class Moduels? (frm Leo) 2
Creating UDF by Class Module (Leo)? 1

Top