Hiding a button when hiding rows

[richard_m_ferguson]

Hi Guys,

Can someone help me out. I'm trying to hide some rows and some of
these rows have buttons on the cells.

When I hide the rows that buttons just all bunch up and stay visible.

Is it possible to associate the button with a cell and hide the button
when the rows are hiden?

Thanks,
Richard.

 

[Ian]

In design mode, right click on the button and select Format
Control>Properties>Move and size with cells, then OK it.

 

[Traveller]

By "design mode" do you mean Normal view mode, as opposed to "View Page
Breaks" mode?

 

[Gord Dibben]

Design mode is found on the Control Toolbox.

Ian has made the assumption that Richard's buttons were created using the
Control Toolbox.


Gord Dibben MS Excel MVP

 

[Traveller]

Thanks for clearing that up, Gord.

Design mode is found on the Control Toolbox.

Ian has made the assumption that Richard's buttons were created using the
Control Toolbox.


Gord Dibben MS Excel MVP