View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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