LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 126
Default Selecting Autoshapes in Excel 2003

Hello!

If we select an autoshape object in Excel 2003 for instance a rectangle on
sheet1 something like 'Activesheet.Shapes("Rectangle 6").Select will get
written on Visual Basic coding sheets. The problem to me is this code would
not work if that rectangle was replaced with an other one because the new one
will be "Rectangle7".

Can an expert help me on this?

Thanks.

Varne M
 
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
Excel 2007 and Autoshapes Varne Excel Discussion (Misc queries) 2 May 24th 08 01:58 PM
How do you change the default text alignment for Excel autoshapes bk2001 Excel Discussion (Misc queries) 1 May 18th 07 03:22 PM
Can I select and Group Autoshapes in Excel 97 ? diglas1 via OfficeKB.com New Users to Excel 17 June 13th 06 02:42 AM
delete multiple autoshapes or objects in excel ron Excel Discussion (Misc queries) 3 January 26th 06 03:01 PM
Hide AutoShapes On Excel Worksheet Dave Y Excel Worksheet Functions 5 June 12th 05 04:26 AM


All times are GMT +1. The time now is 02:37 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"