Loop through closed workbooks

[YasserKhalil]

Hello everyone
I have a code that enables me to loop through closed workbooks
The closed workbooks are set to Manual calculation
How can I set the calculation to Automatic in these closed workbooks ..??

The code saves the workbooks and close it at the end of the code
Thanks advanced for help

 

[Nebu]

Hi:

I guess you will have to include the following line before closing the work book( May be in the particular work book close event.)
Application.Calculation = xlAutomatic

Thanks

 

[YasserKhalil]

That is very weird
I already tried this line more than a try and it didn't work ...
After your post I restarted my pc and tried again and everything is ok now .. It is working
Thank you very much for great help here and there
Best Regards

 

[Debaser]

Remember that Excel's calculation mode is set by the first workbook opened in a session. So if you opened one workbook that was set to manual then opened another that was saved with automatic, calculation would still be manual.

 

[YasserKhalil]

Thanks a lot Mr. Debaser for this useful information ..