View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Selecting Drawing Object By Name

Thank you, Gary. Turning record on and selecting the shape gave me the
same answer! Guess I was having a senior moment there. <g Happy
Holidays! James
Gary Keramidas wrote:
i named a shape square.

activesheet.shapes("square").select

--


Gary


"Zone" wrote in message
ps.com...
I have several drawing objects on a worksheet. I have assigned each of
them a name. How do select the object by using its name in VBA code?
Excel 2002. TIA, James