Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have imported some code to enlarge the window while
picking data valadation lists from the Contextures website When i put these on the same sheet code module I get an compile error mesaage It won't let me use Worksheet_SelectionChange twice on the same sheet module what is the best solution to this? Is it alright just to insert the second line of code after the first without the Private Sub Worksheet...sentence. Thanks in advance for any help Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$A$2" Then ActiveWindow.Zoom = 120 Else ActiveWindow.Zoom = 100 End If End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rngDV As Range Application.EnableEvents = False On Error Resume Next Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation) On Error GoTo 0 If rngDV Is Nothing Then Exit Sub If Intersect(Target, rngDV) Is Nothing Then ActiveWindow.Zoom = 100 Else ActiveWindow.Zoom = 120 End If Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Help with some simple code | Excel Discussion (Misc queries) | |||
simple code | Excel Programming | |||
Help With Very Simple Code | Excel Programming | |||
Simple For Each Next code | Excel Programming |