+ Reply to Thread
Results 1 to 3 of 3

VBA Help - turning autocalculations off

  1. #1
    Registered User
    Join Date
    01-01-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    26

    VBA Help - turning autocalculations off

    Hi,

    Hoping someone can help. I have managed to create the following VBA that I think will disable autocalculations for Sheet 1 in a spreadsheet. However, I would like to create a longer script that disables autocalculations for sheets 1.2,3,4,5,6,7,8,9 and 10 - noting I have 18 sheets in the spreadsheet. Please can someone help create this for me? I am OK on simple scripts like below but I am not a programmer and not sure how to make this longer to cater for my needs.


    Sub DisableCalc()
    Sheet1.EnableCalculation = False
    End Sub


    Many thanks,

    Nick

  2. #2
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: VBA Help - turning autocalculations off

    Hi,

    Will sheets 11-18 depend on sheets 1-10 in order to be calculated?

  3. #3
    Registered User
    Join Date
    01-01-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: VBA Help - turning autocalculations off

    Thanks for your reply Jarko - I have now managed to resolve this.

    Thanks for your help though.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1