+ Reply to Thread
Results 1 to 3 of 3

Workbook Macro to change calculations from manual to automatic?

  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    OKC, Ok
    MS-Off Ver
    Excel 2007
    Posts
    4

    Workbook Macro to change calculations from manual to automatic?

    I would like to set up my excel workbook so that when the workbook is opened a message box will pop up with a YES or NO selection and if you click YES the file will open with automatic calculations but if you click no the file would open with manual calculations.

    Could anyone help me figure out how to set this up?

    thanks!

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Workbook Macro to change calculations from manual to automatic?

    something like this (in ThisWorkbook module)
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,003

    Re: Workbook Macro to change calculations from manual to automatic?

    Hi Phil_Packer,

    The below code needs to be pasted into the Personal workbook area in the VB IDE.

    Go to 'Developer' >> 'Visual Basic' and have look at the attached picture.

    NOTE - This practice is not recommended as it is very easy to forget the autocalc setting is off & could lead to incorrect results being reported.

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by noboffinme; 12-15-2013 at 12:45 AM.
    Remember you are unique, like everyone else

+ 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. Replies: 0
    Last Post: 06-09-2011, 10:31 AM
  2. Automatic and manual calculations
    By Muttley in forum Excel General
    Replies: 0
    Last Post: 03-20-2006, 11:10 AM
  3. [SOLVED] RE: Automatic and manual calculations
    By bpeltzer in forum Excel General
    Replies: 0
    Last Post: 03-20-2006, 10:55 AM
  4. Difference btween Automatic and Manual calculations.
    By WannaBeExceller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2006, 05:30 PM
  5. Replies: 2
    Last Post: 09-29-2005, 11:05 AM

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