how to make a function defined in one workbook being called by other workbooks

**anshulbansal** · 06-10-2008, 11:24 PM

Hi All,

I have defined a function in one of the workbook. This function works fine in this workbook. However when I try to execute the same function in the other workbook, it does not work since the function is not defined in the other workbook. How do I make this function defined in one workbook to work with any other workbook. I have defined the function as Public. I have also tried to define the function in the personal.xls file which gets loaded up every time MS Excel opens. But none of the solutions work.

Any help would be greatly appreciated.

Thanks,

Anshul

**Leith Ross** · 06-11-2008, 12:04 AM

Hello anshul,

It would be easier to answer your question if you posted the function.

Sincerely,
Leith Ross

**royUK** · 06-11-2008, 01:33 AM

It might be something as simple as referencing the ActiveWorkbook, as leith says we need to see the code.

**The AD** · 06-11-2008, 03:06 AM

Dear Leith
I have attached a file with macro of a function, so that you can give solution for me, and Anshul.

Sincerely,
The AD

**anshulbansal** · 06-11-2008, 09:47 AM

Attached is the spreadsheet that contains the function. Here is the function anyway:

Please Login or Register  to view this content.

**royUK** · 06-11-2008, 09:58 AM

Originally Posted by The AD

Dear Leith
I have attached a file with macro of a function, so that you can give solution for me, and Anshul.

Sincerely,
The AD

Take the time to read the Forum Rules & you will see that you should not ask your question in another member's post. Post your own question.

**royUK** · 06-11-2008, 10:05 AM

Place your code in a new workbook and save it as an addin (*.xla).Excel will automatically save it to the addins folder. From the Tools menu select Addins & browse for your addin to complete installation

The Function will then be available to any workbook.