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

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

That will not select a 'checkbox' object. The 'checkbox' is a 'Forms'
object. I need to be able to set all 'checkboxes' to "checked" or "unchecked"
by clicking one button.

"Shane Devenshire" wrote:

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