Where to put UDFs

**BlairH** · 06-10-2010, 11:25 AM

I created a used defined function in a module in a worksheet and it works fine. I copied it to Module1 in personal.xls as a public function, but can't access it from other worksheets.

Is there a place to put public functions where they can be used from within any worksheet?

Thanks!

**DonkeyOte** · 06-10-2010, 11:27 AM

You would need to prefix with the file name, ie:

=PERSONAL.XLS!functioname()

Most would use an Add-In though...

**BlairH** · 06-10-2010, 11:56 AM

Thanks. Would this be the best info on how to create an add-in?

http://www.ozgrid.com/VBA/excel-add-in-create.htm

**royUK** · 06-10-2010, 01:05 PM

Try this for basic,or more advanced see this

**BlairH** · 06-10-2010, 02:13 PM

Thanks to both for your answers.

**royUK** · 06-10-2010, 02:15 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save