In the checkbox which when true it will check all other check boxes yo
can do this:

if checkbox6 then
checkbox5 = true
checkbox4 = true
checkbox3 = true
checkbox2 = true
checkbox1 = true
end if

note that changing the value will cause the click event for eac
individual check box to execute

--
Message posted from http://www.ExcelForum.com