Modeless Userform
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 |
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 |
Modeless Userform
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 |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com