View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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.