View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hide Buttons along with Rows

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.



wrote:

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


--

Dave Peterson