Results 1 to 3 of 3

Thread: *Resolved* Excel VBA: Freeze Worksheet Calculation?

Threaded View

  1. Sep 25th, 2005, 01:48 PM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Resolved *Resolved* Excel VBA: Freeze Worksheet Calculation?

    Hi,

    Is there any way to freeze (prevent) a number of worksheets from recalculating when a VBA macro is running?

    I have a spreadsheet with about 10 worksheets, most of which are linked to each other in some way. One of my macros only needs to use the formulas (and related results) from about 7 of these, so the other 3 are updating all the time but since the results from these are not needed then they are slowing down my code.

    Is there some VBA function for temporarily disabling a worksheets calculation function? I would need my code to look something like this:

    Code:
    Worksheet("sheet1").Calculate:False
Worksheet("sheet2").Calculate:False
Worksheet("sheet3").Calculate:False

*Execute the macro code*

Worksheet("sheet1").Calculate:True
Worksheet("sheet2").Calculate:True
Worksheet("sheet3").Calculate:True
    Is something like this possible?

    Thanks
    -Rob
    Last edited by TheRobster; Oct 6th, 2005 at 06:13 PM.
    http://www.sudsolutions.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width