B
Bura Tino
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
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