![]() |
#5
|
|||
|
|||
![]() 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 For Each osubshp In ActiveWindow.Selection.ChildShapeRange osubshp.Fill.ForeColor.RGB = vbRed Next Exit Sub err: MsgBox "Is a shape selected?", vbCritical End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Struggling with this one. In-line Cell formatting again | TJMorgan | Excel Programming | 9 | 02-16-2017 10:37 AM |
![]() |
LadyG | Excel | 6 | 01-26-2017 09:49 AM |
![]() |
Moondoggy | Word | 2 | 08-08-2016 07:38 PM |
![]() |
jayhammond | Word VBA | 3 | 03-04-2016 08:58 AM |
![]() |
riccam87 | Excel | 1 | 05-02-2014 07:21 AM |