In the hopes of making my macro run faster, I'd like to prevent the
formulas of certain tabs/sheets in my workbook from refreshing (ie.
the designated sheet would not update when I press F9).

Could somone please teach me how to do this?

Please note I am not asking to stop screen refreshes - instead I'd be
grateful if someone could show me how to stop formulas on a sheet from
being refreshed when I hit F9.

Thanks so much for your help!