Macro to tick checkbox automatically

[PaulJ]

Hi,
I have a spreadsheet with a macro assigned to a button, with a checkbox
(from the control toolbar) next to this button for the user to manually tick
when they have run the macro. Is there a way for the checkbox to be ticked
automatically when the button is clicked?
Thanks!

[Tom Ogilvy]

Just add code in the macro assigned to the button

Activesheet.CheckBox1.Value = true

--
Regards,
Tom Ogilvy


"PaulJ" <PaulJ@discussions.microsoft.com> wrote in message
news:63CBF6A1-8B50-4D86-9D0B-F3E7C09E5504@microsoft.com...
> Hi,
> I have a spreadsheet with a macro assigned to a button, with a checkbox
> (from the control toolbar) next to this button for the user to manually
tick
> when they have run the macro. Is there a way for the checkbox to be
ticked
> automatically when the button is clicked?
> Thanks!

[PaulJ]

Thanks Tom, I've adapted this slightly as my checkboxes aren't necessarily
CheckBox1. I've inserted the following code into my macro and it works
nicely:

With ActiveSheet
.Checkboxes.Value = True
End With

I wondered if anyone knows whether checkboxes can be protected? Ideally I
would like my macro to determine whether the checkbox is ticked or not.

Regards, Paul

"Tom Ogilvy" wrote:

> Just add code in the macro assigned to the button
>
> Activesheet.CheckBox1.Value = true
>
> --
> Regards,
> Tom Ogilvy
>
>
> "PaulJ" <PaulJ@discussions.microsoft.com> wrote in message
> news:63CBF6A1-8B50-4D86-9D0B-F3E7C09E5504@microsoft.com...
> > Hi,
> > I have a spreadsheet with a macro assigned to a button, with a checkbox
> > (from the control toolbar) next to this button for the user to manually
> tick
> > when they have run the macro. Is there a way for the checkbox to be
> ticked
> > automatically when the button is clicked?
> > Thanks!
>
>
>