VBA function missing its parameters

[LA Writer]

I'm creating my first VBA Excel formula in a couple years. I can pic
the formula in the list of available functions, but the function'
parameter is not visible. If I assign the formula to the cell anyway
the cell only shows: #NAME?

So, even when I pick the formula from the module, Excel complains abou
the name.

For example, the formula in the cell looks like:
=test.xls!Module3.DoubleText()
I can force a parameter into the function call,
=test.xls!Module3.DoubleText("abc")
but it doesn't matter since Excel doesn't see the parameter in th
function definition.

The example function is:
Function DoubleText(text As String) As String
DoubleText = text & text
End Function

Please help. How do I add a new VBA function with parameters?

Thanks

 

[LA Writer]

Turns out this was probably a Macro security issue... But I'm not sure,
since I shouldn't have to exit Excel to change the security settings.

All I know is that my formulas are working now.