UDFs in Excel

[guymason]

Can you attach User Defined Functions so that they are always available to Excel and not just attached to a particular Worksheet?

Many Thanks


Guy

 

[ETID]

Yes compile a single workbook with all your functions in it, and "save as" (select .xla as type from drop down) and name it something like "my_functions.xla" and save it to the addins folder located in your Office directory structure.


restart excel ...goto tools>addins and and they should be in the AddInns list by function name.

 

[guymason]

Sounds great, I'll give it a try.

Thanks
Guy

 

[TonyJollans]

Hi guymason,

More normally, you put them in your [blue]Personal.xls[/blue] file.

If you don't have one, the easiest way to create one and make sure it's in the right place is to record a macro

Select Tools > Macro > Record New Macro...
Under Store macro in: in the Dialog box, Select Personal Macro Workbook and Press OK
Do something (anything) and Stop Recording (either on the Stop Recording Toolbar which should be displayed or by Tools > Macro > Stop Recording)
Reply Yes when prompted to Save when you close Excel.

Every time you open Excel after that the Personal Macro Workbook will be automatically opened and available to use or to add new code to.



Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[01Patrik]

Or put them in 'book.xlt' (under office/templates/workbooks or something like that). Here you can put your default headers / footers as well since it is the file that automaticly opens up when you select "new workbook".



// Patrik