Calculate workbook in VBA
 

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

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