Renaming pictures
If you have bunch to do try this.
Public Sub ReNamePics()
Dim Pic As Shape, K As Long
For Each Pic In Selection.ShapeRange
K = K + 1
Pic.Name = "Log" & K
Next Pic
End Sub
Gord Dibben MS Excel MVP
On Mon, 26 May 2008 03:07:01 -0700, Henk wrote:
Thanks Norm. It works!
"Norman Jones" wrote:
Hi Henk,
Try something like:
ActiveSheet.Pictures("Picture 1").Name = "Log 01"
---
Regards.
Norman
"Henk" wrote in message
...
Is it possible to change the name of pictures in a workbook? E.g. rename
Picture 52 (name given by Excel itself) to Log 01.
Regards
|