Macro to clear checkboxes and protected cells

[Guy]

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

 

[Shane Devenshire]

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]

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.