| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| when hiding columns mess: "cannot shift objects off sheet" | Excel Discussion (Misc queries) | |||
| Hiding objects based on property of object | Excel Programming | |||
Hybrid Mode
