[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

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

Originally Posted by ranman256

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

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

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