| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NAME? in cell when opening a Workbook
I have some Excel VBA code that I saved as a .XLA Add-In file. I then have
this XLA set as an Add-In inside of Excel. If I enter my UDF into a cell, it works correctly and returns the values that I expect. Every time I re-open a Workbook that contains calls to my UDF in the Add-In, all cells that call the UDF have " #NAME? " in the cell. Excel goes through and recalculates these cells and all is correct and #NAME? is replaced with the output of the UDF for the cell. Why does Excel have to resolve the reference to this Add-In each time it opens? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a link in a workbook cell to edit?? | New Users to Excel | |||
| Active Cell when opening workbook | Excel Worksheet Functions | |||
| Opening a workbook based on a cell value | Excel Programming | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
![J. Caplan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
