View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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