Hiding a button when hiding rows

  • Thread starter Thread starter richard_m_ferguson
  • Start date Start date
R

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.
 
In design mode, right click on the button and select Format
Control>Properties>Move and size with cells, then OK it.
 
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
 
Thanks for clearing that up, Gord.

Gord Dibben said:
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
Click to expand...
 
the button should have under properties the options of move and size with cell. Play about to get the desired effect
 

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

Similar Threads

Hide drop downs 1
Expand and collapse rows 7
Hide rows in table based on 1 empty cel of the same row. 1
Code to hide rows if cell in another WS is ="No" 11
Hide multiple rows when particular cell is zero 17
Excel EXCEL - using a date dependant formula to hide rows 3
Hide Row 4
Hide Unhide Button 4

Back
Top