| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to active cell after macro completes
After running a macro that was activated by a button, the button stays on
focus and I have to press the Escape Key to return to the active cell. What can I do to prevent this? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return to active cell after macro completes
activecell.select
or activecell activate Dan "Dave" wrote: After running a macro that was activated by a button, the button stays on focus and I have to press the Escape Key to return to the active cell. What can I do to prevent this? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return to active cell after macro completes
activecell.select
But whic cell this is can depend on what your macro does. Dan Hatola wrote: activecell.select or activecell activate Dan "Dave" wrote: After running a macro that was activated by a button, the button stays on focus and I have to press the Escape Key to return to the active cell. What can I do to prevent this? Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return to active cell after macro completes
If it's a command button from the Controls Toolbox, you can
TakeFocusOnClick=false. NickHK "Dave" ... After running a macro that was activated by a button, the button stays on focus and I have to press the Escape Key to return to the active cell. What can I do to prevent this? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return to active cell | Excel Discussion (Misc queries) | |||
| In macros, an instruction that will return the position of the Active Cell | Excel Programming | |||
| Need VBA macro to return active cell address (R1C1) | Excel Programming | |||
| how can I return the active row and active column? | Excel Programming | |||
| Public variable is reset after addin macro completes - thread/focus pblm? | Excel Programming | |||
Hybrid Mode
