| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ctrl+F command | Excel Discussion (Misc queries) | |||
| Stop running macro button, like Ctrl-Break button | Excel Programming | |||
| Stop running macro button, like Ctrl-Break button | Excel Programming | |||
| Stop running macro button, like Ctrl-Break button | Excel Programming | |||
| Deselect Command Button by Selecting another Command Button | Excel Programming | |||
Linear Mode
