Hide Buttons along with Rows

A

adambush4242

In one of my workbooks I frequently hide rows that are not needed for current
analysis and then unhide them as needed. These rows contain buttons that
affect only the data contained in the corresponding rows. Therefore, I would
like to be able to hide the rows as well as the buttons in these rows.
However, when I currently hide, the buttons appear on the visible row right
after the last hidden row. Is there any way to hide these buttons along with
the rows?

Thanks

Adam Bush
 
E

Earl Kiosterud

Adam,

In the Format (or Format Control) dialog for the buttons, look at the Properties tab. Set
it to "Move and size with cells."

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
D

Dave Peterson

What kind of buttons--and what toolbar did you use to make them?

If you rightclick on the object, you can choose Format Control.
On the properties tab, you can choose to move and size with cells.

Some controls (like optionbuttons and checkboxes from the Forms toolbar) don't
have that option.

But you could replace them with optionbuttons and checkboxes from the control
toolbox toolbar.
 
A

adambush4242

Thanks a lot for your help guys. Changing the format control to Move and
Size with Cells worked perfectly.

Adam Bush
 

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

Top