A command button that works while in manual mode??

[TDeRanger]

My worksheet recalculates a formula every time I enter something new on spread sheet. I switch the worksheet into manual mode & I am aware of the "calculate now or (F9)" buttons but what I am needing is a command button that works while in manual mode.

Thanks for any advise in advance

[cytop]

What has a command button got to do with the calculation mode...?

[TDeRanger]

I need the command button to manually calculate a formula while in manual mode (don't want to use F9 or calculate now buttons if possible). My command button that I have now doesn't work when I'm in manual mode.

[TDeRanger]

I uploaded the worksheet and have call out boxes to explain myself better. Please see attach file.

[TDeRanger]

I found how to write the vba code to calculate a formula while in manual mode for excel, then used a command button to execute the formula.