Shapes changing size and position when hiding columns

**trimmjens** · 03-30-2015, 08:06 PM

I have a userform with an OK button to show/hide some columns if a checkbox is true/false.

It is working very well, but sometimes when the OK button is pressed and the checkbox is false,
almost all (not all) of the shapes in the visible sheet are changing size and position.

I have no codes for such actions.

Any ideas to why this may happen?

Here is the code:

Please Login or Register  to view this content.

Thank you

**Chris 53** · 03-31-2015, 03:49 AM

Have you checked the properties of the shapes? There is an option to 'Don't move or size with cells'. The other settings will cause the shapes to move, or resize or both.

**trimmjens** · 03-31-2015, 11:49 AM

Yes, I've set the properties of the shapes to Don't move or size with cells.

Some of the shapes get back to their original position and size when i zoom in and out. But the rest of them shrinks and move position for each time the OK button is pressed.

It's very difficult to work with when it only happens sometimes.