Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 27th 11, 03:32 AM posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 49
Default Stopping one sheet from calculating

Hi folks.

Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?

Thanks

xt

  #2   Report Post  
Old June 29th 11, 07:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 15
Default Stopping one sheet from calculating

Hi,

Put this first "Application.Calculation = xlCalculationManual" then
"Calculate" after running your macro.

Hope it will help!
~jaeson
  #3   Report Post  
Old June 29th 11, 07:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 15
Default Stopping one sheet from calculating

On Jun 27, 10:32*am, Xt wrote:
Hi folks.

Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?

Thanks

xt



Hi!

First use this "Application.Calculation = xlCalculationManual" and in
End "Calculate"

Hope it will help!
~jaeson
  #4   Report Post  
Old June 29th 11, 09:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2,059
Default Stopping one sheet from calculating

On Jun 26, 7:32*pm, Xt wrote:
Is there a way to turn the calculation of a particular
sheet off and on using VBA while the VBA is working with
data from another sheet?


No. Automatic v. manual calculation mode applies to the entire
workbook, not individual sheets. In fact, I believe it applies to all
workbooks open in the same Excel instance.

However, after setting Application.Calculation=xlCalculationManual,
you can use Sheets("sheet1").Calculate to cause one worksheet to
recalculate.
  #5   Report Post  
Old June 30th 11, 12:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 420
Default Stopping one sheet from calculating

Depends on the version of excel you're running.

Look in VBA's help for EnableCalculation.

If you find it (and all the versions of excel that you need to support have
it!), then read the help.




On 06/26/2011 21:32, Xt wrote:
Hi folks.

Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?

Thanks

xt


--
Dave Peterson


  #6   Report Post  
Old July 1st 11, 10:35 PM posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 49
Default Stopping one sheet from calculating

On Jun 30, 11:20*pm, Dave Peterson wrote:
Depends on the version of excel you're running.

Look in VBA's help for EnableCalculation.

If you find it (and all the versions of excel that you need to support have
it!), then read the help.

On 06/26/2011 21:32, Xt wrote:

Hi folks.


Is there a way to turn the calculation of a particular sheet off and
on using VBA while the VBA is working with data from another sheet?


Thanks


xt


--
Dave Peterson


Thanks to you all. Very helpful. xt


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating a time sheet? tb Excel Worksheet Functions 4 August 4th 05 09:25 AM
Sheet has stopped calculating... mailrail Excel Discussion (Misc queries) 1 July 13th 05 05:10 PM
Stopping A Sheet From Scrolling mully New Users to Excel 5 June 9th 05 03:38 PM
Auto Calculating Time Sheet Durocdog Excel Worksheet Functions 1 June 7th 05 09:54 AM
Calculating an AVG from data on another sheet flummoxed Excel Worksheet Functions 3 January 19th 05 03:25 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017