enable UDF in 2007

Splith

Board Regular
Joined
Mar 26, 2009
Messages
88
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top