ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to hide a form button in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/143455-how-hide-form-button-worksheet.html)

angie ng

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

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


All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com