On Feb 13, 12:55*pm, Harlan Grove wrote:
Regardless, you may be better off commenting out all formulas that
call udfs, adding a new blank worksheet, moving all other worksheets
except this new blank one into a new workbook, and saving this new
workbook. This will effectively strip the VBA modules out of this new
workbook. Then add macro code from the original workbook into the new
workbook via copy and paste, BUT BE CAREFUL TO PASTE ONLY ONE VERSION
OF EACH UDF. Once you've copied the code to the new workbook, edit the
formulas containing udf calls to delete the workbook and module

This did the trick. Apparently, I had made some minor change to the
name of the function (case I think) which goofed everything up. I
renamed everything to ACAT, and it works beautifully now.

I don't suppose that Excel has some method of managing UDF's? Seeing
what is available, allowing you to 'clean' or 'wipe' them out, and
maybe entering contextual help for the UDF?

Thank you so much for your help.


-Josh