Autocalculate when adding new worksheets via VBA 1

[TimGoose]

I have an excel spreadsheet with VBA behind it. The spreadsheet has a "Template" worksheet which has all my formula etc on it. The VBA loops through data (originally obtained via SQL) and for each time through the loop:

1. Creates a new worksheet
2. Gives it a unique name
3. Copies all the formula etc from the "Template" to the new worksheet.

All that is working fine. However, every time a new worksheet is added it appears that Excel does an automatic recalculate, even though I have turned this off in the VBA.

Questions:

1. Does Excel ALWAYS do a recalculate when a worksheet is added?
2. Is it possible to stop this?

Many thanks

Tim

 

[SkipVought]

please post your code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TimGoose]

Typical! Someone points me back at my VBA and I spot the problem myself.

Although I can't be sure, it looks as if forcing a cell with no formula in it to calculate makes the whole sheet recalculate. However, the basic reason why the new sheet was recalculating was because I was telling it to.

Thanks, Skip!