Naming shapes

Giganews Newsgroups
Subject: Naming shapes
Posted by:  Ian Jones (anonymo…@discussions.microsoft.com)
Date: Tue, 28 Oct 2003

Is there a workaround/explanation for the way Excel
names/references Shapes:

Open a new workbook and draw a rectangle onto a sheet.
Excel will name it "Rectangle 1"
First question - Can I rename it?

Delete "Rectangle 1".
Draw another rectangle onto the same sheet.
Excel will name it "Rectangle 2".

How can I control the naming of Shapes?
Or at least have a sequential/logical/simple(!!) way of
referencing/controlling/manipulating what could be a large
number of similar/dissimilar Shape objects.

Thank You!

Exasperat....

Replies