View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diego Anaya Diego Anaya is offline
external usenet poster
 
Posts: 1
Default Excel 2007 is slow when you hide columns on .xls

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