Hiding Objects Along with Rows
 

Hi,

I have some code to hide rows (Rows("7:133:).hidden = true). However, when
executed, it does not hide the objects in these rows and pushes them all to
the top of the page. How can I hide the objects as well?

TIA,
Harry

Hiding Objects Along with Rows
 

I think it depends what the objects are.

Sometimes, you can rightclick on the object and choose Format Control (on some
objects), then properties tab and choose to move and size with cells.

But some objects (like checkboxes from the Forms toolbar) don't support this.

Harry F. wrote:

Hi,

I have some code to hide rows (Rows("7:133:).hidden = true). However, when
executed, it does not hide the objects in these rows and pushes them all to
the top of the page. How can I hide the objects as well?

TIA,
Harry

--

Dave Peterson