Hello:

I have excel worksheet with number of sheets.
Each sheet does lots of lookup and calculation.
This slows down my work.
i have some sheets which can be updated manually. I am feeling that doing this way would speed up my work.

So i need to assign some sheets with auto calculate and some with manual calculate....Is this possible to have a macro or VB Coding so that only certain sheets are on Auto Calculate and rest of the others would be on manual calculate.

Thank you in advance...