Macro to clear checkboxes and protected cells

  • Thread starter Thread starter Guy
  • Start date Start date
G

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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to clear checkboxes 5
Excel macro help needed 0
vba solution for protection 3
checkbox in a protected worksheet 2
Macro clear cells if meet 1 condition 8
Protected cells can't be grouped 1
Add a checkbox to a spreadsheet 2
To Clear number in the cell(s) 6

Back
Top