Forum Discussion
Looking to hide content unless a check box is clicked in the file.
This is going to sound probably a bit odd, but I'm trying to organize some stuff for a video game. I have several mods installed, and I want to make the excel file friendly for people who don't use mods and use mods (as I also swing between the two). Essentially, I want to mark certain content to appear and disappear when a check box is engaged and disengaged.
Hopefully I explained that alright. Is there a way to do something like that in excel?
One way to do this without VBA code is to group rows:
Click +/- to expand or collapse groups:
With check boxes, a few lines of VBA code are needed.
Both approaches are demonstrated in the attached workbook. To view the code, right-click the sheet tab of Sheet1 and select View Code from the context menu.
(You'll have to allow macros when you open the workbook in the desktop version of Excel)
Thank you! I will give this a try. ^.^
I put in the code. I altered it a bit to hide specific cells, but nothing is vanishing using the VBA options. I'm not sure what I've done wrong.
See the attached workbook for a non-VBA alternative.
If with html summary tag e.g.
https://e.anyoupin.cn/EData/1400.html
https://developer.mozilla.org/en-US/docs/Web/HTML/Element/details
