Funny function problem with add-ins...
Hi,
I have an add-in which has worksheets in it, which are templates that I copy
out. Now, I also have a function
Function stupid() As Double
stupid = 5
End Function
and one of the cells in the worksheet-to-be-copied-out says =stupid()
Unfortunately, when the spreadsheet is copied out of the add-in, that cells
now says #NAME?. If I double-click into and press Enter, in goes back to
"5". Is there a way to avoid this problem?
Thanks,
Bura
|