Is there a way to know programatically what shape or group of shapes are presently active? Poking around the VBA Object Browser, I did not find anything like "ActiveShape" nor did I find a shape property like "Active" or similar.
Is there a way to know programatically what shape or group of shapes are presently active? Poking around the VBA Object Browser, I did not find anything like "ActiveShape" nor did I find a shape property like "Active" or similar.
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
Try this.
[vba]
Dim Shp As Variant
On Error Resume Next
For Each Shp In Selection
MsgBox Shp.Name
Next
On Error GoTo 0
[/vba]
thanks. That is an interesting and useful approachOriginally Posted by DRJ
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.