+ Reply to Thread
Results 1 to 5 of 5

[Is it possible?] Calculate only Active Worksheet without having to execute a macro.

  1. #1
    Registered User
    Join Date
    02-04-2015
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    14

    [Is it possible?] Calculate only Active Worksheet without having to execute a macro.

    Hi there, been searching everywhere did not find anything so not sure if it is possible.
    I have a workbook that has on one of its sheets a matrix formula that is very resource hungry so every time that I type anything on Sheet1 excel hangs for 10s so it will update this matrix formula.
    Sheet1 has many formulas (all of them referring to Sheet1) so I need to find a way to turn on calculation only to active sheet. I saw that it is possible to do that but I need to execute the macro every time or press Shift F9 that would update only the active worksheet.
    I donít know how to do it but I was thinking that if I could find a way that every time that I type something on any cell of Sheet1 make a VBA code that would press Shift F9. If there is any other, easier way please let me know.
    Iīve had to set Workbook Calculation to Manual. Let me know if I can set it back to automatic, and prevent this matrix sheet of calculating automatically.

    Thanks in advance.

    Sururu

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,033

    Re: [Is it possible?] Calculate only Active Worksheet without having to execute a macro.

    While in manual mode, Cant you just press the F9 key to recalc?

  3. #3
    Registered User
    Join Date
    02-04-2015
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    14
    Quote Originally Posted by ranman256 View Post
    While in manual mode, Cant you just press the F9 key to recalc?
    Ranman256 this worksheet is for data input And has many other formulas that needs to be activated every time I type so basically I have to press shift F9 after every input, thats why wanted to do it automatically.

    Regards

  4. #4
    Registered User
    Join Date
    02-04-2015
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    14

    Re: [Is it possible?] Calculate only Active Worksheet without having to execute a macro.

    How to trigger a macro everytime I update a cell? Maybe it will work this way?

  5. #5
    Registered User
    Join Date
    02-04-2015
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    14

    Re: [Is it possible?] Calculate only Active Worksheet without having to execute a macro.

    Hi there, I am still looking for an solution, if someone could help, i would be glad.

+ 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. Execute a macro in a closed workbook, or open and execute without the user noticing
    By cearaujo123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2015, 06:44 PM
  2. [SOLVED] VBA to check for active sheet then execute following code
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2013, 12:48 PM
  3. [SOLVED] Convert Macro to Execute Upon Worksheet Activate
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2013, 08:20 PM
  4. Macro to edit active chart on active worksheet
    By shlurpee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2011, 04:58 AM
  5. [SOLVED] How to execute a macro in a protected worksheet?
    By Ha Noi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2006, 01:05 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