I have written a simple function (just for test) (opening VBA with alt-F11):

Public Function XX()
XX = 7.45
End Function

but when I use it in a cell - it just shows #NAME?

How do I make the function known to my sheet?

What could be wrong?