Using VBA To Keep Auto-Calculation On But Turn Off In Case One Worksheet’s Auto-Filter Is Used

[Aimee S.]

Hello Everyone,

I am looking for a means, if one is possible, from a VBA standpoint to have an .xlsm file auto-calculate formulas in all cases with the exception of, hypothetically, ‘Sheet1’ auto-filter usage.

I ask this because all other aspects of my file utilize drop downs that various formulas throughout the workbook reference, so auto calls are a must for those, but in the event users try and work with the eight-to-12 thousand row, many, many columned data to find information behind the dashboards, they won’t have to wait for Excel to auto calculate each time the auto filter is changed on that ‘Sheet1’ worksheet.

Any ideas? Immense thanks for your time and expertise.

Aimee in Madison

 

[Logit]

.
At the beginning of your code for that sheet you can add :

[FONT=&quot]Application[/FONT][FONT=&quot].[/FONT][FONT=&quot]Calculation[/FONT][FONT=&quot] [/FONT][FONT=&quot]=[/FONT][FONT=&quot] [/FONT][FONT=&quot]xlManual


Then at the end you can add:

Application.Calculation = xlAutomatic[/FONT]