Hi Keith,
To change the name property of a shape or picture in Excel, you can follow these steps:
- Select the shape or picture that you want to rename.
- Go to the "Format" tab in the ribbon.
- Click on the "Selection Pane" button in the "Arrange" group. This will open the "Selection Pane" on the right-hand side of the screen.
- In the "Selection Pane", you should see a list of all the shapes and pictures on your worksheet. Find the one you want to rename and click on its name.
- The name should become editable. Simply type in the new name you want to give it and press Enter.
Alternatively, you can also rename a shape or picture using VBA code. Here's an example:
Formula:
Sub RenameShape()
Dim shp As Shape
Set shp = ActiveSheet.Shapes("Picture 1") 'replace "Picture 1" with the current name of your shape or picture
shp.Name = "New Name" 'replace "New Name" with the name you want to give it
End Sub
Hope this helps!