View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rbnorth rbnorth is offline
external usenet poster
 
Posts: 9
Default Unrecognized functions in *.XLA

In an attempt to centralize my common VBA functions for several files, I
saved the function modules in a *.XLA file in my XLSTART directory. I then
went back to the original spreadsheet and deleted the function modules. Now,
even though the addin is shown as active and the functions are even
acknowleged in the 'insert function' toolbar, I only get #NAME? errors for
the addin functions show on the original spread sheet. If I open up a new
blank spreadsheet the functions work ok . Can anybody tell me what I need to
do to get the original spreadsheet to recocnize the add in functions?