This project has moved. For the latest updates, please go here.

How to set Checkbox checked to true?

Jan 27, 2011 at 12:15 PM

Hi all,

I have an .xlsm template which contains some check boxes. I've tried all sorts of ways to set them to checked but I'm not having any luck.

Does anyone have a preferred method of doing this is, if it can be done??

Many Thanks, Dan

Jan 30, 2011 at 5:14 PM


No, there is not support to set the value of a checkbox in the library in the current version, but I guess you can do it from a VBA-macro.


Jan 31, 2011 at 9:30 AM

Ok, thanks Jan.

I managed to get away with linking the Check boxes to a cell outside of the print region and just set those to 1 / 0 or TRUE / FALSE. Works great so far!!!

Many thanks to all who contributed to this project, it's helped me out more than I have time to work out!!!!