brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a multi sheet workbook but a lot of formulas on 1 sheet which is slowing down the workbook significantly because of the calculations being automatic and the numbers involved. I do not want to disable automatic calculation for the whole workbook but only for the one sheet named "Control"
When open this worksheet, only then do I want to activate the automatic calculations on this sheet and when I leave the worksheet I want to deactiveate the automatic calculations for that sheet only. Is there a way to do this with VBA in the worksheet code?
When open this worksheet, only then do I want to activate the automatic calculations on this sheet and when I leave the worksheet I want to deactiveate the automatic calculations for that sheet only. Is there a way to do this with VBA in the worksheet code?