Take Focus Off of CommandButton When Exiting UserForm
 

Greetings,

I have a Toolbar CommandButton on my worksheet that is used to call up
a UserForm. When I exit the UserForm, the CommandButton still has the
focus.

Is there anyway to restore the focus to the worksheet as I exit the
UserForm?

Your help is greatly appreciated.

TIA

-Minitman

Take Focus Off of CommandButton When Exiting UserForm
 

CommandBars.ReleaseFocus

"Minitman" wrote:

Greetings,

I have a Toolbar CommandButton on my worksheet that is used to call up
a UserForm. When I exit the UserForm, the CommandButton still has the
focus.

Is there anyway to restore the focus to the worksheet as I exit the
UserForm?

Your help is greatly appreciated.

TIA

-Minitman

Take Focus Off of CommandButton When Exiting UserForm
 

Thanks

-Minitman


On Fri, 17 Nov 2006 11:45:02 -0800, JLGWhiz
wrote:

CommandBars.ReleaseFocus