maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
Hi All,
I have an excel file with many tabs. I need a macro to AutoCalculate only few sheets based on text in cell.
Need a macro to turn On/Off autocalculate based on text in cell.
If a text in Cell is "ABC" then i need sheet1, sheet5, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
If a text in Cell is "MNO" then i need sheet4, sheet7, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
If a text in Cell is "XYZ" then i need sheet10, sheet11, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
Can someone help me.
Thanks in Advance.
Mahi
I have an excel file with many tabs. I need a macro to AutoCalculate only few sheets based on text in cell.
Need a macro to turn On/Off autocalculate based on text in cell.
If a text in Cell is "ABC" then i need sheet1, sheet5, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
If a text in Cell is "MNO" then i need sheet4, sheet7, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
If a text in Cell is "XYZ" then i need sheet10, sheet11, sheet6 and sheet9 need to Calculate and rest all sheets should not calculate.
Can someone help me.
Thanks in Advance.
Mahi