Command Button Ctrl+Alt+Shift_F9
 

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

Command Button Ctrl+Alt+Shift_F9
 

And what does Ctrl+Alt+Shift+F9 do? I have not memorized all of the
keyboard combinations yet.



"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

Command Button Ctrl+Alt+Shift_F9
 

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

Command Button Ctrl+Alt+Shift_F9
 

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

Command Button Ctrl+Alt+Shift_F9
 

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

Command Button Ctrl+Alt+Shift_F9
 

My guess would be the 4-finger Ctrl+Alt+Shift+F9 combination is somewhat
cumbersome, a simple mouse click isn't.

--
Rick (MVP - Excel)


"JLGWhiz" wrote in message
...
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

Command Button Ctrl+Alt+Shift_F9
 

On the other hand, I can't remember ever using either the code or the shortcut
key.



Rick Rothstein wrote:

My guess would be the 4-finger Ctrl+Alt+Shift+F9 combination is somewhat
cumbersome, a simple mouse click isn't.

--
Rick (MVP - Excel)

"JLGWhiz" wrote in message
...
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



--

Dave Peterson

Command Button Ctrl+Alt+Shift_F9
 

Thank you for the suggestion it works great.

To answer JLGWhiz's post: The workbooks will go to a client. I figured it
would be easier to place an 'Update Data' button on the worksheet than write
text in a cell that says: "To update data press Ctrl+Alt+Shift+F9".

"Dave Peterson" wrote:

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

Command Button Ctrl+Alt+Shift_F9
 

Hi Lonnie, That makes sense to do a little human engineering on the user.
Posting the objective will always get you an quicker and better solution.



"Lonnie" wrote in message
...
Thank you for the suggestion it works great.

To answer JLGWhiz's post: The workbooks will go to a client. I figured it
would be easier to place an 'Update Data' button on the worksheet than
write
text in a cell that says: "To update data press Ctrl+Alt+Shift+F9".

"Dave Peterson" wrote:

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