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

"Bura Tino" wrote in message
news:lRnhc.37737$yD1.111611@attbi_s54...
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?

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


Thanks,

Bura