Quote:
Originally Posted by Guessed
In my experience with floating shapes in the headers, VBA seems to think all the shapes are in every section even though the user interface shows a graphic only in one sections header. This can be further complicated when some headers may have 'Link to Previous' turned on.
So I have no faith at all in being able to use VBA to determine which shape you are referring to via the section number.
|
To do that, you need to get the header index and check backwards through that Section and each preceding Section to determine where the .LinkToPrevious attribute (if applied to the current Section) ends. That Section is the one in which the shape actually exists.
12-05-2022, 04:10 PM
Similar Threads
How do I make a checkbox or dropdown item reference data in that specific section of the data array?
Windows 10 
Office 2016
Threaded Mode