Solved it. Checked boxes were linked to named cell and the sheet / cell was protected. Removing protection from those cells solved the problem. Not a very useful error message form Mr. Excel lol.