D
Diego Anaya
Hi everybody, I have a macro that hide a few columns on excel model 2003, but
acttually i'm using excel 2007 and is too slow, to hide this columns takes 1
minutes, here is the code.
Application.ScreenUpdating = False
Application.Calculation = xlManual
With ActiveSheet
For i = 1 To 11
Worksheets(aNombreHojas).Columns(5 + i).Hidden = true
Next
End With
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
acttually i'm using excel 2007 and is too slow, to hide this columns takes 1
minutes, here is the code.
Application.ScreenUpdating = False
Application.Calculation = xlManual
With ActiveSheet
For i = 1 To 11
Worksheets(aNombreHojas).Columns(5 + i).Hidden = true
Next
End With
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic