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
|