I am trying to assign macros to individual shapes in an Excel 2007 worksheet, and I cannot find a way to identify the shape.
Is there a provision for editing the shape name or viewing the properties?
I am trying to assign macros to individual shapes in an Excel 2007 worksheet, and I cannot find a way to identify the shape.
Is there a provision for editing the shape name or viewing the properties?
Last edited by Alley oop; 08-10-2012 at 12:53 PM.
If you click the shape, you should be able to see/edit it's name in the name box (near top left)
Regards,
Vandan
Thank you so much. That was so simple, I am red-faced.![]()
Also check the Selection Pane.
Home > Editing > Find & Select > Selection Pane.
Thank you! I did not know that tool existed. It is really helpful to be able to see all objects on the sheet. I found some orphaned comments which I did not know about.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks