Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In Excel 2003 you have the possibility to bring a txt box to front and a text
box to the back: ActiveSheet.Shapes("Rectangle 23").Select Selection.ShapeRange.ZOrder msoSendToBack ActiveSheet.Shapes("Rectangle 24").Select Selection.ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 29").Select Selection.ShapeRange.ZOrder msoBringToFront Range("E12").Select In 2007 version. The rectangles are not recognized in Macro recording but in the sheet it is also not possible to bring them backwards. It seems to be that you work in different layers. In my sheet you can make 1 choice. At that moment the other 2 possibilities are partly hidden via a withe rectangle. This works perfect in 95-2003 version but not in 2007. How can I solve this problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What are the reasons for ""ActiveSheet.Paste Link:=True"" failure | Excel Programming | |||
how to show the position of shapes like "rectangle" | New Users to Excel | |||
activesheet.shapes("Group 1...n") | Excel Programming | |||
Why doesn't 'Range("A65000").Select' work? | Excel Programming | |||
Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select | Excel Programming |