隐藏行时隐藏复选框 [英] Hide checkboxes when hiding rows

问题描述

我已经使用VBA代码隐藏了一些行.当我单击复选框时，这些行是隐藏的.

I have used VBA code to hide some rows. These rows are hidden when I click a check box.

我现在遇到的问题是-与每行关联的复选框不会隐藏.这也干扰了我原来的VBA代码以隐藏行并停止工作.我想隐藏这些带有行的复选框.

The problem I have now is - the check boxes associated with each row will not hide. This also interferes with my original VBA code to hide the rows and stops working. I would like to hide these check boxes with the rows.

请您提出建议吗?

推荐答案

您需要将复选框设置为移动单元格并调整其大小".我上一次使用Excel 2003这样做很容易:右键单击，选择属性"，然后选择该选项.现在，如果您尝试该操作，将会看到该选项，但该选项已被禁用:

You need to set the checkboxes to "Move and Size With Cells." The last time I did this, with Excel 2003 it was easy: just right-click, choose "Properties" and choose that option. Now if you try that you'll see the option, but it's disabled:

因此，您需要从Excel 2007开始访问外观更现代的格式菜单.我是通过单击绘图工具"选项卡的格式"组上的小更多"箭头来实现的.由于某种原因，该功能已在此处启用.设置好之后，您的复选框将与其行一起隐藏:

So instead you need to access the more modern-looking format menu in Excel 2007 onwards. I did it by clicking the little "more" arrow on the Drawing Tools tab's Format group. For some reason it's enabled there. Once you set it your checkbox will hide with its row:

这篇关于隐藏行时隐藏复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！