Здравствуйте
Так нужно?[vba]Код
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name <> "Лист1" Then
Application.ScreenUpdating = False
Select Case Sheets("Лист1").[a2]
Case 1
Columns("a:k").Hidden = False
Columns("l:aa").Hidden = True
Columns("ab:ak").Hidden = True
Case 2
Columns("a:k").Hidden = True
Columns("l:aa").Hidden = False
Columns("ab:ak").Hidden = True
Case 3
Columns("a:k").Hidden = True
Columns("l:aa").Hidden = True
Columns("ab:ak").Hidden = False
Case Else
Columns("a:k").Hidden = False
Columns("l:aa").Hidden = False
Columns("ab:ak").Hidden = False
End Select
Application.Goto Cells.SpecialCells(12).Areas(1).Cells(1, 1), 1
Application.ScreenUpdating = True
End If
End Sub
[/vba]
UPD Фигню спорол, исправил