That might do it. I am trying to figure out the difference in the amount of
effort it takes to press Ctrl+Alt+Shift+F9 and clicking a button.


"Dave Peterson" wrote in message
...
That sounds like
Application.CalculateFullRebuild
(xl2003 or greater?????)

For all open workbooks, forces a full calculation of the data and rebuilds
the
dependencies.

====
If that's not right, maybe just using application.sendkeys would be
sufficient????



JLGWhiz wrote:

I found it:

Rechecks dependent formulas and then calculates all cells in all open
workbooks, including cells not marked as needing to be calculated.

Maybe somebody will take the time to create a macro that is redundant to
this.

"Lonnie" wrote in message
...
I would like to place a Command Button in an excel worksheet so that
pressing
it would be the same as pressing 'Ctrl+Alt+Shift+F9'

Thank you

--

Dave Peterson