Hi,
Hoping someone can help. I have managed to create the following VBA that I think will disable autocalculations for Sheet 1 in a spreadsheet. However, I would like to create a longer script that disables autocalculations for sheets 1.2,3,4,5,6,7,8,9 and 10 - noting I have 18 sheets in the spreadsheet. Please can someone help create this for me? I am OK on simple scripts like below but I am not a programmer and not sure how to make this longer to cater for my needs.
Sub DisableCalc()
Sheet1.EnableCalculation = False
End Sub
Many thanks,
Nick
Bookmarks