Resetting picture index number?

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Is it possible to reset or assign a different picture number to a
picture recently copied on a worksheet? I use excel 2003

Thank's ahead
 
Is it possible to reset or assign a different picture number to a
picture recently copied on a worksheet? I use excel 2003

Thank's ahead
Click to expand...

Forgot to mention, if this could be done with VBA and how.
 
Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim
 
Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim




- Show quoted text -
Click to expand...

Yes Tim the picture are being pasted via VBA !
 
Immediately after pasting the picture, you should be able to access it via

Activesheet.shapes(activesheet.shapes.count)

You can then set its Name property to whatever you need.

Tim


Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim




- Show quoted text -
Click to expand...

Yes Tim the picture are being pasted via VBA !
 
Immediately after pasting the picture, you should be able to access it via

Activesheet.shapes(activesheet.shapes.count)

You can then set its Name property to whatever you need.

Tim





Yes Tim the picture are being pasted via VBA !- Hide quoted text -

- Show quoted text -
Click to expand...

Tim will sound simplistic, but I take a chance. If the picture name
is: picture 20 how do you rename it?
Is it: Activesheet.shapes("picture 20").name = Activesheet.shapes
("picture 40")
 
Tim will sound simplistic, but I take a chance. If the picture name
is: picture 20 how do you rename it?
Is it: Activesheet.shapes("picture 20").name =  Activesheet.shapes
("picture 40")- Hide quoted text -

- Show quoted text -
Click to expand...

Tim I did found out! Thank you again for your suggestion.
 
Back
Top