View Single Post
 
Old 04-24-2018, 06:18 AM
R Mohan R Mohan is offline Windows 8 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 15
R Mohan is on a distinguished road
Default

Quote:
Originally Posted by JohnWilson View Post
Code:
Sub chexSA()

Dim osubshp As Shape
Dim oshp As Shape
On Error GoTo err
Set oshp = ActiveWindow.Selection.ShapeRange(1)
If Not oshp.HasSmartArt Then
MsgBox "This does not look like you have a Smart Art shape selected!", vbCritical
Exit Sub
End If
Set osubshp = ActiveWindow.Selection.ChildShapeRange(1)
osubshp.Fill.ForeColor.RGB = vbRed
Exit Sub
err:
MsgBox "Is a shape selected?", vbCritical
End Sub
Hi John,

Amazing, thanks a ton !!

Appreciate your timely and accurate response !
Reply With Quote