How to Modify the style of a picture with VBA

[R Tanner]

Hi,

I have copied a range of cells and pasted them as a picture in my
code. I want to modify the style of the picture to have a shadow.
What is the procedure for that?

Thanks

 

[R Tanner]

Hi,

I have copied a range of cells and pasted them as a picture in my
code. I want to modify the style of the picture to have a shadow.
What is the procedure for that?

Thanks

The problem arises because I can't see any of the syntax with the
macro recorder. I change the style, and it records zilch....

 

[Barb Reinhardt]

I think I'd do something like this

myShape.ShapeRange.Shadow.Type = msoShadow5

 

[Dave Peterson]

One more to try:

Dim myShape As Shape
Set myShape = ActiveSheet.Shapes("Picture 1")
myShape.Shadow.Type = msoShadow5

 

[R Tanner]

One more to try:

Dim myShape As Shape
Set myShape = ActiveSheet.Shapes("Picture 1")
myShape.Shadow.Type = msoShadow5

okay Thanks. I will try your suggestions...