Hi,
I have a UDF that works perfectly in xl2003, but fails to auto recalc on workbook open in xl2010. I have to hit F9 and then it will work perfectly thereafter.
I've tried inserting "Application.Calculate" and "Application.Calculation = xlCalculationAutomatic" into Workbook_Open in ThisWorkbook to force a recalc on open, but it still fails.
Thoughts?
Lawrence
Bookmarks