Copying spreadsheet out of excel with formulas (pressing)
 

Hi,

My vba add-in relies on having spreadsheets (which represent templates)
which it copies out on demand. These worksheets use functions defined in the
addin, as simple as this silly one:

Function five() As Double
five = 5
End Function

Unfortunately, when the sheet is copied to another workbook, the cell that
depends on that formula shows up as #NAME?. If I click into the cell and
press enter it works. (This is a big problem because I have about 100 such
formulas in each template.

Can anyone suggest a solution?

Many thanks in advance!

Bura