Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Very Slow Worksheet Calculation
I have code that runs on activation of a sheet to unprotect it, filter out
zero rows, and reprotect. Since I added this code to the workbook it calculates very slowly - not only the sheet it runs on, but all sheets. I am fairly new to use of VBA. See code: Option Explicit Private Sub Worksheet_Activate() ' ' Autofilter Macro ' ' Application.Calculation = xlCalculationManual Application.ScreenUpdating = False ActiveSheet.Unprotect ActiveSheet.Range("$A$1:$N$74").Autofilter Field:=1, Criteria1:="<0", _ Operator:=xlAnd ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _ False Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Calculation | Excel Discussion (Misc queries) | |||
worksheet very slow in calculation | New Users to Excel | |||
Slow Calculation | Excel Worksheet Functions | |||
Does this slow down calculation? | Excel Discussion (Misc queries) | |||
Slow calculation | Excel Programming |