VBA for auto calculating some sheets and not other.

[sahil]

Dear Folks,

I am new with VBA. I have two large workbooks each of which is having enormous data with multiple links and formulas, Now it becomes very irritating whenever I do any change to any cell in the sheet, it takes to long to update the entire sheet and then I become able to do another change in the cell.

I google and found that by disabling auto calculation I can get over of this issue, I did this and it worked well, the only issue is I dont know whatever I am doing is right unless I press F9 to update.

This should be sorted out with two ways.

1) If the auto calculation is only done in the sheet which are visible and not which are hidden. (This workbook needs to be sent to seniors)

2) If the auto calculation is only done in the sheet which is active for the moment and not other sheets. (it is my workbook with has much of row data, hence I want to auto calculate only one sheet, whichever I select.)

The Problem is I am not good in VBA hence looking for a kind support of one of you guys.

hopefully I will get one.

Thankyou.