Shapes not resizing/staying with pertinent row when "unhide" rows is done

[wbstadeli]

Hi,

I have a worksheet that has been working great until recently, and I cannot seem to figure out what I changed so this no longer works. Basic concept of what it is doing and the current issue: There is code that copies a named range, which has hidden rows that have shapes in those specific rows (these shapes run separate macros). The properties of the shapes are indeed "Move and size with cells". However when this named range is copied (that has the hidden rows inside that range) when i "unhide" those rows the shape is suppressed to a "zero" height at the top of row that was just made to "unhide". Does anyone know how to correct this issue? I'm using Microsoft excel 2016. Thanks!

 

[sijpie]

Strange that it should just happen. Not sure if Microsoft provided an update to your version of Excel recently?

What happens when you manually increase the height of one of these shapes. Then hide the row again and unhide? Does the height then go back to normal, or does it again go to 0?

 

[wbstadeli]

Sorry for the late reply. If I manually resize it seems to be working properly, ill have to take a closer look at my code to see if I can determine when this issue happens.

 

[sijpie]

You can loop through each of the shapes to determine which is in the row that is unhidden, then set its width and height to the correct number

 

[wbstadeli]

Good idea, thanks for the suggestion!