LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What are the reasons for ""ActiveSheet.Paste Link:=True"" failure CAPTGNVR Excel Programming 9 July 7th 07 09:56 PM
how to show the position of shapes like "rectangle" Sumeth New Users to Excel 0 July 7th 07 05:48 AM
activesheet.shapes("Group 1...n") Andreww Excel Programming 1 May 18th 07 11:14 AM
Why doesn't 'Range("A65000").Select' work? Alan[_36_] Excel Programming 6 January 23rd 06 12:19 AM
Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select Harold Good Excel Programming 3 January 13th 06 09:09 PM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"