close
Rather than setting application.calculation to xlAutomatic (or using
application.calculate), you might just use ActiveSheet.Calculate as necessary
w/in the smaller spreadsheet.
quot;Muttleyquot; wrote:
gt; I have a large spreadsheet that has manual calculations. Part of the macro
gt; opens up another smaller spreadsheet that I would like to have as automatic
gt; calculations. When this opens I have some VB that sets this up to be
gt; automatic, but this seems to set the big spreadsheet up to automatic as well,
gt; resulting in a v long calculation.
gt;
gt; Is there anyway just to have the small spreadsheet set up as automatic?
gt;
gt; Thanks.
全站熱搜
留言列表
