M
marc21
Guest
Bonjour a tous,
Ma question, quand je met unprotec et protect , j'ai toujours une erreur lors du lancement de ma macro, Je suppose que c'est l'emplacement qui est erroné...., je l'ai enlever, mais à quel endroit du code doit il etre ?
voila mon code :
Sub Feuille1 ()
Msg = Sheets("Feuille 1").Cells(18, 18) ' "Attention."
Style = vbYesNo + vbCritical + vbDefaultButton2
Title = "Attention.... RAPPEL !!!"
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then
Sheets("Année 04").Select
ActiveWindow.SmallScroll Down:=-15
Range("B310:z339").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("novembre 04").Select
Range("A5").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Range("A1:U1").Select
End If
End Sub
Merci d'avance
Marc21
Ma question, quand je met unprotec et protect , j'ai toujours une erreur lors du lancement de ma macro, Je suppose que c'est l'emplacement qui est erroné...., je l'ai enlever, mais à quel endroit du code doit il etre ?
voila mon code :
Sub Feuille1 ()
Msg = Sheets("Feuille 1").Cells(18, 18) ' "Attention."
Style = vbYesNo + vbCritical + vbDefaultButton2
Title = "Attention.... RAPPEL !!!"
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then
Sheets("Année 04").Select
ActiveWindow.SmallScroll Down:=-15
Range("B310:z339").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("novembre 04").Select
Range("A5").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Range("A1:U1").Select
End If
End Sub
Merci d'avance
Marc21