ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hiding checkboxes (https://www.excelbanter.com/excel-programming/397364-hiding-checkboxes.html)

Tammy H

Hiding checkboxes
 
I have a spread sheet that has several check boxes. When a certain check box
is checked I need to hide other check boxes along with hiding the row. I
know how to hide the row when a check box is ticked but I need help hiding
the check boxes. Is this possible? Any help would be appreciated.

JNW

Hiding checkboxes
 
set the visible property to false. i.e. checkbox1.visible = false.
You'd do this in the same event that you would use to hide rows.
--
JNW


"Tammy H" wrote:

I have a spread sheet that has several check boxes. When a certain check box
is checked I need to hide other check boxes along with hiding the row. I
know how to hide the row when a check box is ticked but I need help hiding
the check boxes. Is this possible? Any help would be appreciated.



All times are GMT +1. The time now is 07:17 AM.

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