View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Calculate workbook in VBA


"Doug" wrote in message
...
Hi,

I would like to calculate an one entire workbook and leave other open
workbooks alone. I see that I can calculate one sheet, or the entire
application, but I don't see how I can do a whole workbook.

If I calculate the workbook one sheet at a time, the interdependence of

the
sheets leaves some calculations behind.

Thanks,
Doug


Maybe this helps.
http://www.decisionmodels.com/calcsecretsh.htm

/Fredrik