Hello,

I have some code like the one in the attached sample file. A checkbox form control has a macro assigned that triggers certain actions whether the cell link is True or False. If True, there's no problem. But if False, I need to have the workbook go into manual calculation first, otherwise it will trigger a circular argument before the code can be executed. Doing it without code or checkbox, I would first choose manual calculation, copy and paste values, and then enable automatic calculation. With the checkbox, as soon as it's checked, I can't then turn on manual calculation. It's too late.

Any ideas?