Macro to tick checkbox automatically
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" wrote in message
...
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!
|