Manual calculate sheet formulas

Hello,

I have a file with several sheets that contain data with formulas (mostly VLOOKUP). sheet 1 contains about 15,000 formulas that make it very difficult to work with the file.
unlike all other sheets on this fie, I don't need auto calculations of those formulas, i want to manually calculate this sheet value when ever I need to. all other sheet should be calculate automatically as of now.
I cannot separate this sheet of the file because it will make the work very cumbersome and can be disastrous.

Thanks

hi, yrndtn, you can run this code with the sheet in question being active.

1. This one stops automatic calculation for the active sheet

Please Login or Register  to view this content.

2. This one resumes automatic calculation for the active sheet

Please Login or Register  to view this content.

Thanks,

While I'm trying this, is there a way to define a shortcut (button, key combination) to run it manually instead of turn automatically calculation on/off?

you can assign shortcut to any macro by selecting code in Macro list and Parameters or it can be done via VB:

CTRL+SHIFT+m - stop automatic calculation for activesheet
CTRL+SHIFT+a - resume automatic calculation for activesheet

check attachment, try those shortcuts and change values in A1-A2