View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Modeless Userform

A simple way the usually works, called in a modeless userform -

AppActivate Application.Caption

Regards,
Peter T

"Roger" wrote in message
...
Is ther a way to return focus back to the worksheet automatically after a
user hase clicked a button on a permanently displayed modeless userform
--
Roger