Hi,

I have four worksheets and I require 3 to be automatically calculated but the forth worksheet I need to be excluded when automatically calculating (Ill press Shift F9 to manually calculate it)

The Names of the worksheets in VBA are:
Sheet 1 (Summary)
Sheet 5 (1129)
Sheet 6 (1130)
Sheet 7 (1240)

I need the sheets 1129,1130 and 1240 set to automatic and the Summary sheet set to manual

Can anyone supply me with the VBA code?