Thread
:
Hide Buttons along with Rows
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson