How to Modify the style of a picture with VBA
 

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

How to Modify the style of a picture with VBA
 

On Aug 19, 12:35 pm, R Tanner wrote:
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....

How to Modify the style of a picture with VBA
 

On Aug 19, 7:42 pm, Dave Peterson wrote:
One more to try:

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

R Tanner wrote:

On Aug 19, 12:35 pm, R Tanner wrote:
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....

--

Dave Peterson

okay Thanks. I will try your suggestions...