Excel - Need to Hide a Picture

[TDugan]

In Excel, I am using code to hide rows in certain situations. The issue is that a picture I have in one of the rows isn't hiding like the text. I think I need to add code specifically for the picture, but not sure what syntax should be used.
The Sheet is called "T404 Full". The picture label is "Picture 5". Can someone send me info on how this should be coded? I would appreciate it. Thanks.

 

[SkipVought]

hi,

if the height of the picture greater than the height of the row?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TDugan]

Hi,
Yes, the height of the picture is bigger than the height of the row. Thanks for your help.

 

[SkipVought]

Is the Size and Properties > Properties TAB > Object Positioning [highlight]Move & Size with cells[/highlight]?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TDugan]

It is currently set to Move but don't size with cells. Do I need to change that to the option you indicated?

 

[SkipVought]

Nothing is stopping you, is there?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TDugan]

Worked beautifully! Thank you very much!

 

[SkipVought]

Don't be reluctant to try stuff!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]