UDF not showing up

[Roderick_E]

I'm adding UDF macros into Personal but they neither show up on worksheets when I start typing =nameoftheUDF nor in the QAT under macros. What's going on?
Thanks

**UPDATE*** looks like competing "Personal" files

 

[shg]

By default, Personal opens as a hidden workbook rather than as an add-in. There are three ways to use UDFs in Personal, each with advantages and disadvantages.

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F2F2F2"]

Method​

[/td][td="bgcolor:#F2F2F2"]

Advantage​

[/td][td="bgcolor:#F2F2F2"]

Disadvantage​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]Use as Hidden and qualify UDF names: Preface the function name with workbook name, e.g.,

=Personal.xls!MyFunc(...)[/td][td]Personal’s macros appear in the Macros dialog. No reference required.[/td][td]A lot of typing[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]Use as Hidden and set a reference: Name Personal’s VBA project something recognizable (like projPersonal) so you can find it in Tools > References, and then set a reference.[/td][td]Personal’s macros appear in the Macros dialog[/td][td]You might be inclined to put the reference in your standard workbook template (Book.xlsx in XLSTART), but that can cause problems. Suppose the workbook actually doesn’t use any of Personal’s UDFs, but does have some code of its own. If you send the workbook to someone else, they’ll get a missing reference error, and be unable to use the code until it’s removed.[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]Use as an Add-In: With Personal hidden, set the IsAddIn property to True and then save.[/td][td]No reference required[/td][td]Personal’s macros do not appear in the Macros dialog[/td][/tr]
[/table]

I find the last method to be most convenient, because I seldom use the macros in Personal, but use the UDFs every day.

Note that macros that require arguments will never appear in the Macros dialog.

 

[shg]

Note that macros that require arguments will never appear in the Macros dialog.

I should have said Subs.

My working definition of a macro is a Sub that doesn't take arguments. It's not precise, but it's a useful distinction.