PDA

View Full Version : Private Function problem



kualjo
05-21-2010, 07:04 PM
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
05-22-2010, 01:46 AM
Functions will recalculate on every change. Try setting Calculation the Manual, then resetting to Automatic at the end of your sub.