Hiding Objects Along with Rows

H

Harry F.

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is row visible? 2
hiding blank rows 3
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Integrating information from Word to Excel (not mail merge) 1
Create form with checkbox les that expand and collapse sections of the form? 0
Shared Workbooks & Code 1
Linked pictures to cell dropdown 0
SheetCalculate fires all the time 3

Top