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 how to hide a form button in a worksheet

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.



angie ng wrote:

When I hide some rows of a worksheet, the form button is still appear on the
worksheet, how do hide the button as well?


--

Dave Peterson