Do not shift focus when users click userform

John Yazou · Mar 25th, 2002, 05:52 PM

Hi all,
I wrote a macro for Attachmate Extra! personal client. Due to company policy, they disabled the macro running feature on the software. Luckily, the software supports VBA & I was able to access the objects using Excel. The macro is executed when users press a command button I put on a form loaded with Excel ie control Attachmate Extra! using Extra. My question:
1. In Excel -> Whenever users press the command button, the focus is shifted to Excel. I have not been able to disable the TakeFocus******* for the Application/UserForm class. Any way to do this??

BabyTiger · Mar 25th, 2002, 08:14 PM

Hi,

Do you mean the focus is on Excel worksheet once the button is click? Or perhaps the focus remains on the Userform itself?

John Yazou · Mar 25th, 2002, 11:12 PM

I want the focus to remain on the application I am controlling. My solution at the moment is to do SendKeys "%{TAB}" to alt-tab back to Extra!. Wondering if there's a more elegant solution...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 05:52 PM	#1
John Yazou New Member Join Date: Mar 2002 Posts: 49	Hi all, I wrote a macro for Attachmate Extra! personal client. Due to company policy, they disabled the macro running feature on the software. Luckily, the software supports VBA & I was able to access the objects using Excel. The macro is executed when users press a command button I put on a form loaded with Excel ie control Attachmate Extra! using Extra. My question: 1. In Excel -> Whenever users press the command button, the focus is shifted to Excel. I have not been able to disable the TakeFocus******* for the Application/UserForm class. Any way to do this??

Mar 25th, 2002, 08:14 PM	#2
BabyTiger Board Regular Join Date: Mar 2002 Location: Wellington Posts: 104	Hi, Do you mean the focus is on Excel worksheet once the button is click? Or perhaps the focus remains on the Userform itself?

Mar 25th, 2002, 11:12 PM	#3
John Yazou New Member Join Date: Mar 2002 Posts: 49	I want the focus to remain on the application I am controlling. My solution at the moment is to do SendKeys "%{TAB}" to alt-tab back to Extra!. Wondering if there's a more elegant solution...