View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Excel global setting for all workbooks? Calculation Automatic

To All,

I have a workbook running VBA code that "causes all my" workbooks to change
from Calculation Automatic to Calculation Manual... until I can get to the
bottom of this problem...

Is there a global setting "effecting all workbooks" that will reset the
Calculation back to Automatic. Or is a macro "effecting all workbooks"
required to achieve this - if so, could you please supply the code achieving
this result?

Thanks, Ben