I am trying to display a freeform shape on top of a label control. In
Excel 2002, I used an EMBED("Forms.label.1","") or EMBED("Forms.Image.
1","") control in a worksheet. Using that control, I used mouse_down
events to determine the point coordinates (ex. digitizing a picture of
a shape) and put those on the sheet for further processing. This
worked perfectly in 2002, but now with Excel 2007, I am having a
problem where the lable or image control stays in front of any shapes
drawn obscuring the view of mouse clicked points. The points or lines
were in front of the control, but now they are not. I have tried to
send the control to the back, but it doesn't work. Any suggestions on
how to get this to work?
Thanks in advance.
Rock
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
