الاخوة الكرام
ارجوا ضم الكودين في كود واحد شكرا
Sub Button286_Click()
Dim x1, i As Integer
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:="ehab123"
Columns("d:iq").EntireColumn.Hidden = True
If ActiveSheet.Shapes("Drop Down 6").ControlFormat.Value = 33 Then
Columns("d:iq").EntireColumn.Hidden = False
Range("d6").Select
ElseIf ActiveSheet.Shapes("Drop Down 6").ControlFormat.Value = 32 Then
For i = 11 To 251 Step 8
Cells(1, i).EntireColumn.Hidden = False
Next
Range("k6").Select
Else
x1 = ActiveSheet.Shapes("Drop Down 6").ControlFormat.Value
Range(Cells(1, ((x1 - 1) * 5) + x1 * 3 + 1), _
Cells(1, ((x1 - 1) * 5) + x1 * 3 + 1 + 7)).EntireColumn.Hidden = False
Cells(6, ((x1 - 1) * 5) + x1 * 3 + 1).Select
End If
ActiveSheet.Protect Password:="ehab123"
End Sub
Sub copy()
Range("g2").copy Range("ah" & [ah1000].End(xlUp).Row + 1)
Range("c3").copy Range("ai" & [ai1000].End(xlUp).Row + 1)
Range("c4").copy Range("aj" & [aj1000].End(xlUp).Row + 1)
Range("g4").copy Range("ak" & [ak1000].End(xlUp).Row + 1)
Range("g3").copy Range("al" & [al1000].End(xlUp).Row + 1)
Range("c5").copy Range("am" & [am1000].End(xlUp).Row + 1)
End Sub