I have kind of a weird situation here at work. I have an '.xlsm' workbook that has a number of macros built into it. One of the sheets in it has many, many lines. We have check boxes beside each line so that after you check them off and then you can run a macro to hide all non-checked lines. I have had it working on previous machines and when I send the file to others in the office, they are able to use the checkboxes without issue. I have tried the following solutions...all with no luck.

- save as a new file
- ensure 'enable content' was selected when opening the file
- through trust center I have opened everything up so there are no active x and macro restrictions
- added the file location to the trusted center.

Just for further information, I can go in to developer mode and make modifications to the checkboxes or other active x controls.

Hoping someone knows what else I can look at here!