| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow to open Excel 2007 and Word 2007 (MIS stumped) | Excel Discussion (Misc queries) | |||
| Excel 2007 - Hide & Unhide Columns/Rows | Excel Discussion (Misc queries) | |||
| Excel 2003: VBA - Hide Rows process now too slow | Excel Programming | |||
| excel 2007 slow | Excel Discussion (Misc queries) | |||
| Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming | |||
Threaded Mode
