On Jan 21, 5:55 am, SteveM wrote:
I've built an optimization model and I would like to create a map-like
interface on a worksheet in which selected sites in the solution are
indicated on the map canvas by unhiding drawing objects. So I need to
place the drawing objects on the worksheet as Controls (i.e. Shapes I
think) but how to do that is not clear since the Control tool box
contains pictures but not shape objects.

Any ideas?

Thanks Much,

SteveM

Do the shapes have to be Control objects?
Shapes can be assigned to macros and can be hidden/unhidden by code.

Ken Johnson