how to hide a form button in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I hide some rows of a worksheet, the form button is still appear on the
worksheet, how do hide the button as well?
 
Is this a button from the Forms toolbar--or an optionbutton from the Forms
toolbar--or what???

If it's a button from the Forms toolbar,
rightclick on it
choose Format Control
Properties tab
check Move and size with cells

If it's an optionbutton, you'll notice that there isn't a "move and size with
cells" option under that properties tab.

If you want to hide these shapes, you may find it much easier to use the
optionbuttons from the Control toolbox toolbar.
 

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

Open Specific Worksheet Using Button Form Control in Excel 0
Hide and lock cell formulas without affecting Macro? 4
Toolbar buttons to hide/unhide sheets 8
Command buttons linked to moving rows 2
Hide row before printing 3
hide, unhide column or row after protect worksheet 4
Hide option buttons 2
How to hide rows in an Excel worksheet based on a variable 2

Back
Top