All,

I have a macro that executes Solver for a model I have on a particular worksheet. The problem is that whenever Solver executes it re-calculates not just the worksheet where the model is, but also every other worksheet in the workbook--How do I stop solver doing this? I only want it to calculate the relavent worksheet and not everything else. None of my model functions references any other worksheet, so that doesn't appear to be the problem--Is there some VBa code I can use to solve this issue?

rgds

Freddie.