+ Reply to Thread
Results 1 to 2 of 2

Auto Calc

Hybrid View

aresquare1 Auto Calc 04-08-2015, 08:31 AM
TMS Re: Auto Calc 04-08-2015, 09:06 AM
  1. #1
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    216

    Auto Calc

    If I have a workbook with the macro code below, is there any circumstance where a user on a PC or an Apple computer would NOT have the formulae auto calculate after they make changes to input (short of manually changing the calculation method to manual themselves after they open the model)?

    Thanks for your help.
    RR
    ----------------------------------------
    Private Sub Workbook_Open()

    Application.ScreenUpdating = False

    Application.Calculation = xlCalculationAutomatic

    Application.ScreenUpdating = True
    Sheets("Input").Select
    Range("A1").Select

    End Sub

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,311

    Re: Auto Calc

    Would have thought only if they don't enable macros.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Calc question
    By chdime in forum Excel General
    Replies: 2
    Last Post: 09-26-2007, 05:05 PM
  2. Auto-Calc Problems
    By mindcrash in forum Excel General
    Replies: 2
    Last Post: 06-08-2007, 04:05 PM
  3. Auto calc
    By Jkalsch in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-15-2006, 10:30 AM
  4. Auto Calc
    By ScottS in forum Excel General
    Replies: 0
    Last Post: 02-27-2006, 02:35 PM
  5. auto calc on, but have to edit (f2) cells to force re-calc..help!
    By Curt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2006, 02:10 PM

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