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 m...
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)
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.
