View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Prevent control taking focus when accelerator key is used?

that appears to be by design. I would suggest that as the first command in
the click event you do

ActiveCell.Activate


--
Regards,
Tom Ogilvy

"Michael Jones" wrote in message
...
I can prevent a Command Button taking the focus when it is clicked, by
setting this property to false at design time.
But, this doesn't seem to work when an accelerator key is used - how do I
prevent the Command Button taking the focus when it is activated with an
accelerator key (eg Alt + 1) ?

Using Excel 2003 with Windows XP Professional.

Thanks,

Michael Jones