Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub Creation_Hypertexte() Application.DefaultFilePath = ActiveWorkbook.Path Macro1 Range("A10").Select MyPath = ActiveWorkbook.Path & "" MyName = Dir(".", vbDirectory) i = 0 Do While MyName <> "" i = i + 1 If MyName <> "." And MyName <> ".." And MyName <> ActiveWorkbook.Name Then If (GetAttr(MyPath & MyName) And vbDirectory) = vbDirectory Then ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=MyName, TextToDisplay:="|=>" & MyName & "1" ActiveCell.Font.Underline = False ActiveCell.Offset(1, 0).Select End If End If MyName = Dir(".", vbDirectory) For j = 0 To i MyName = Dir Next ActiveCell.Offset(2, 0).Select Loop With ActiveWorkbook.PublishObjects("Sommaire Auto_21817") .HtmlType = xlHtmlStatic .Filename = _ ".\Sommaire automatique.htm" .Publish (False) End With End Sub
Sub Macro1() ' ' Macro1 Macro ' Macro enregistrée le 19/03/2009 par dolyj ' ' Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone Selection.Borders(xlEdgeBottom).LineStyle = xlNone Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone Selection.Font.ColorIndex = 11 With Selection.Font .Name = "Arial" .Size = 16 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = True .ColorIndex = 11 End With Selection.Font.Bold = True With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .ShrinkToFit = False .MergeCells = False End With End Sub
Sub Macro2() ' ' Macro2 Macro ' Macro enregistrée le 23/04/2010 par bastien ' ' Cells.Select Selection.ClearContents End Sub
Private Sub Workbook_Open() Application.ScreenUpdating = False UserForm1.Show ActiveWorkbook.Saved = True ActiveWorkbook.Close End Sub