Funny function problem with add-ins...

B

Bura Tino

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
 
B

Bura Tino

Bura Tino said:
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?
Click to expand...

Now just wondering if anyone else has had this problem...
 
Top