|
楼主 |
发表于 2019-9-30 15:12
|
显示全部楼层
但是代码里录制不出来:
Sub 宏2()
'
' 宏2 宏
'
'
ActiveSheet.Shapes.Range(Array("Chart 2")).Select
Application.CommandBars("Format Object").Visible = False
ActiveSheet.Shapes("Chart 2").TextFrame2.TextRange.Characters.Text = "市场销售量"
ActiveSheet.Shapes("Chart 2").TextFrame2.TextRange.Characters(1, 5). _
ParagraphFormat.Alignment = msoAlignCenter
With ActiveSheet.Shapes("Chart 2").TextFrame2.TextRange.Characters(1, 5).Font
.BaselineOffset = 0
.Bold = msoTrue
.Caps = msoAllCaps
.NameFarEast = "等线"
.Fill.Visible = msoTrue
.Fill.ForeColor.RGB = RGB(89, 89, 89)
.Fill.Transparency = 0
.Fill.Solid
.Size = 16
.Italic = msoFalse
.Kerning = 12
.Name = "Calibri"
.UnderlineStyle = msoNoUnderline
.Strike = msoNoStrike
End With
End Sub
|
|