How to set focus on a button used in a sheet

[Balasurendra]

Hi, I want to set focus on a button used in an excel sheet and I dont know any function to do so. Can anyone help me in this.

[Chippy]

Here's one way. Change the sheet and command button name as required.

Please Login or Register  to view this content.

[Balasurendra]

Hi Chippy, Thanks for your solution.

But I am using a form control button in my sheet not the command button, I tried with your code for that button but it's not working. Can you help me?

[Chippy]

My code is for a command button from the Control Toolbar (ActiveX controls). These type of buttons automatically change appearance (have a raised effect) when they have focus, therefore the button having focus is apparent to the user.

I experimented with Forms Toolbar buttons (Excel 2003), however they don't change appearance automatically when clicked, therefore the concept of a forms button having focus doesn't apply - I might be wrong though. Maybe your code could set the button's font to bold or another change of appearance to indicate 'focus'.