I assume the checkbox is linked to a cell in the worksheet. Can you make
that cell unlocked?

--
Regards,
Tom Ogilvy

"cjohnson300" wrote in message
...
Does anyone know how to determine (and change) the value of a check box
via
a macro (checked or unchecked) on a protected worksheet. I can make it
work
on a unprotected worksheet but would rather not have to unprotect it every
time

Thanks in advance