How can I view Objects in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an merged cell (which is composed of multiple cells). When I click on
that merged cell is just gives me the upper left corner cell location (which
is correct).

I have some users who wish to draw objects (circles, lines, arcs, etc). in
this cell. They call it their drawing area or cell. What do I need to do to
view the properties of a selected object in excel?

For example, if I select the arc object, I wish to see what name is
associated with that object, its color properties, etc. This way I know how
to references the object to changes its color, etc via VBA code.


Thanks,

Gary
 
Right-click on the object of concern......in the NameWindow, just above
column A will be the name of the object..........select "FormatAutoShape"
from the drop-down, and you can see/select other properties of the object.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top