| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use Shapes in 2007?
In my 2003 excel macro sheet I used:
ActiveSheet.Shapes("Rectangle 23").Select Selection.ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 24").Select Selection.ShapeRange.ZOrder msoBringToFront In 2007 these actions doesn't work. even as I record the action I don't see them in 2007. I like to hide some text to put a rectangle in front. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use Shapes in 2007?
IIRC, the shapes code has changed a lot in 2007. I don't have it available,
so can't test right now. Maybe someone else can assist. I would tweak it for 2003 though. This should get the job done in 2003. ActiveSheet.Shapes("Rectangle 23").ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 24").ShapeRange.ZOrder msoBringToFront -- HTH, Barb Reinhardt "nkat" wrote: In my 2003 excel macro sheet I used: ActiveSheet.Shapes("Rectangle 23").Select Selection.ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 24").Select Selection.ShapeRange.ZOrder msoBringToFront In 2007 these actions doesn't work. even as I record the action I don't see them in 2007. I like to hide some text to put a rectangle in front. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use Shapes in 2007?
It's actually more logical IMO in 2007
With ActiveSheet .Shapes("Rectangle 23").ZOrder msoBringToFront .Shapes("Rectangle 24").ZOrder msoBringToFront End With -- __________________________________ HTH Bob "nkat" wrote in message ... In my 2003 excel macro sheet I used: ActiveSheet.Shapes("Rectangle 23").Select Selection.ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 24").Select Selection.ShapeRange.ZOrder msoBringToFront In 2007 these actions doesn't work. even as I record the action I don't see them in 2007. I like to hide some text to put a rectangle in front. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I use Shapes in 2007?
When I use :
''Sheets("SCORECARD").Select With ActiveSheet .Shapes("Rectangle 23").ZOrder msoBringToFront .Shapes("Rectangle 24").ZOrder msoBringToFront End With Nothing is changing. "Bob Phillips" wrote: It's actually more logical IMO in 2007 With ActiveSheet .Shapes("Rectangle 23").ZOrder msoBringToFront .Shapes("Rectangle 24").ZOrder msoBringToFront End With -- __________________________________ HTH Bob "nkat" wrote in message ... In my 2003 excel macro sheet I used: ActiveSheet.Shapes("Rectangle 23").Select Selection.ShapeRange.ZOrder msoBringToFront ActiveSheet.Shapes("Rectangle 24").Select Selection.ShapeRange.ZOrder msoBringToFront In 2007 these actions doesn't work. even as I record the action I don't see them in 2007. I like to hide some text to put a rectangle in front. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Issue printing shapes in Excel 2007 | Excel Discussion (Misc queries) | |||
| Shapes on 2007 Spreadsheets | Excel Discussion (Misc queries) | |||
| Shapes in 2007 from 2003 | Excel Discussion (Misc queries) | |||
| Formatting shapes with excel 2007 | Excel Discussion (Misc queries) | |||
| 2007: new behavior of grouped shapes | Excel Programming | |||
Linear Mode
