Send picture to back

[jyokom]

How do I send a picture to back with VBA?

 

[robert phillips]

You need to be more specific. Picture located where? Form? spreadsheet?

 

[jyokom]

For example I am using the folowing code to copy and paste an image to a worksheet. I want the Image to be pasted behind another Image already on the worksheet.

If Sheets("FormF").Range("AX35") = True Then
Sheets("Equipment").Shapes("VIP_Door").CopyPicture
Sheets("FormF").Range("N6").Select
ActiveSheet.Paste
Selection.ShapeRange.IncrementLeft 12
Selection.ShapeRange.IncrementTop -2
End If

What is the nomenclature to make the Picture move to back?

 

[robert phillips]

Try something like:

ActiveSheet.Shapes(("VIP_Door").Select
Selection.ShapeRange.ZOrder msoSendToBack 'all the way back
---OR---
Selection.ShapeRange.ZOrder msoSendBackward 'back 1 level


bring it back
Selection.ShapeRange.ZOrder msoBringToFront

 

[jyokom]

thank you. Works exactly as advertised.