Author Topic: How to determine shape underneath another shape  (Read 86 times)

0 Members and 1 Guest are viewing this topic.

doone

  • Jr. Member
  • **
  • Posts: 12
How to determine shape underneath another shape
« on: May 25, 2018, 10:58:54 AM »
Hi Everyone,

I'm interested to know if it is possible to determine what, if any, shapes are underneath another specific shape on a page.  So, for example, let's say I place a line (sheet.1) on the page and then I place a circle (sheet.2) on top of the line.  Is there a formula that I can put in the shapesheet of the circle to get the name of the line underneath?

Something similar was asked in this post http://visguy.com/vgforum/index.php?topic=1119.msg4867#msg4867.  Paul suggested using SpatialSearch method, but that would be a vba solution.  I'm trying to avoid code and just use the shapesheet.

Kind Regards,
Lorna

vojo

  • Hero Member
  • *****
  • Posts: 1104
Re: How to determine shape underneath another shape
« Reply #1 on: May 25, 2018, 10:20:37 PM »
there is a docmd (google it) that allows you to take selected shape and move it to back or front.  No VBA
could use some action cells to do that

or can do manually