Set the Button's TakeFocusOnClick property to False.

In article ,
"Mark1" wrote:

Here's something I discovered. When I run the macro from inside the VBE
using the F8 key, it works. However, when I run it using the command button
on my spreadsheet, it doesn't work. Any ideas?