enable UDF in 2007

[Splith]

I am having trouble accessing the UDF section in the function list. Nor can I get any UDF's to work.

I use excel 2007 and have changed few settings.

 

[SydneyGeek]

Have you enabled macros?
Home button > Excel Options > Trust Centre > Trust Centre Settings.
Pick Macro settings and change the setting to Disable all macros with notification

If you want the workbook to always be enabled, you can trust the location.
Also in the Trust Center Settings, go to Trusted Locations then Add New Location and add your current directory. Check the option to Trust subfolders.

Denis

 

[Splith]

Okay I changed that setting but am still having trouble accessing a function I have written. I am looking for the UDF category in the insert function tool.

 

[Splith]

I have also saved and reloaded the WB.