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)
- OrganizedVideoGamesCopper Contributor
Thank you! I will give this a try. ^.^
- OrganizedVideoGamesCopper Contributor
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.
- SnowMan55Bronze Contributor
See the attached workbook for a non-VBA alternative.
- peiyezhuBronze Contributor
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