Hi,

Start by turning on the recorder and recording the steps you want the macro
to do. If it doesn't do what you need then post the code and explain which
steps fail to meet your need.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Guy" wrote in message
...
I need a macro that will clear several checkboxes on a sheet at once and
also
to clear 'Protected' cells if possible. Prefer one macro but 2 separate
will
do.

Thanks,
Guy