I think Excel calculates before saving, and I think code behind sheets is
less controllable than in modules so its probably running as part of the
recalc. Are you using the calc event?
If you get rid of the selecting then you should not get runtime errors that
depend on specific sheets being active and your code should run significantly
faster.

cheers
simon
" wrote:

Even if I got rid of all the selecting - the problem still exists that
whenever I "save as" all the code runs. Each and every function, which
takes a while. There is nothing in ThisWorkbook, no events BeforeSave,
no modules at all, just code behind the sheets. Again what is peculiar
is this only happens when "saved as", saving works just fine. I even
tried disabling events, which didn't work.