I have an XLA with custom VBA functions in it. All of my users have the addin checked from their addin manager. I have put formulas in cells in another workbook to call my custom functions. They work fine when I create the workbook, but when other people open the workbook, there is a #name? in the call for the function. By doing an F2 enter in the cell, it will work fine. Just an F9 calculate will not solve the error. Why does this happen? Do I have to add code to the workbook to run a simulated F2/Enter every time the book is opened?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problems with an XLA
- Thread starter Hmadyson
- Start date
Similar threads
- Locked
- Question