Private Function problem

[kualjo]

I have a user-defined function that is located within a workbook that starts with Private Function. For some reason, if the workbook is open and I try to run other macros, either in the same or another workbook, they always seem to jump into this function, causing everything to lock up until I hit the Esc key. What am I doing wrong or forgetting to do?

[mdmackillop]

Functions will recalculate on every change. Try setting Calculation the Manual, then resetting to Automatic at the end of your sub.