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.

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.

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.

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.