Create a checkbox and link it to a cell (right click on checkbox,
format, control, link cell). Then set your macro to change the value
of the linked cell to True.
Thank you very much. It was so simple! I didn't know that you could change
the linked cell and it would change the checkbox, i thought it was only vice
versa.