Message 1 of 4
Using Reattach Balloon By Component
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I'm trying to use Balloons.AttachToComponent but not having any success.
The balloons have been orphaned by suppressing the parts. I unsuppressed them before attempting to reattach. Also, reattaching them all at once functions but attaching by component name appears to do nothing. Any thoughts? Thanks
Dim ViewName As String ViewName = "VIEW14" 'ActiveSheet.View(ViewName).Balloons.ReAttach ActiveSheet.View(ViewName).Balloons.AttachToComponent("Part:1") ActiveSheet.View(ViewName).Balloons.AttachToComponent("Part:2")