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

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

Peter - thanks - worked a treat


--
Roger


"Peter T" wrote:

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