Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
After the user clicks the command button and
the code executes, the button is still focused. In code I only know to place Range("A7").Select to unfocus the button. Without this line the button remains focused. If you press the Esc key it unfocuses. I would like the result to be similar to the Esc key with having to select a cell. Possible? How? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
Hi ADK
See the TakeFocusOnClick property of the button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ADK" wrote in message ... After the user clicks the command button and the code executes, the button is still focused. In code I only know to place Range("A7").Select to unfocus the button. Without this line the button remains focused. If you press the Esc key it unfocuses. I would like the result to be similar to the Esc key with having to select a cell. Possible? How? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
After the user clicks the command button and
the code executes, the button is still focused. In code I only know to place Range("A7").Select to unfocus the button. Without this line the button remains focused. If you press the Esc key it unfocuses. I would like the result to be similar to the Esc key with having to select a cell. Possible? How? A kludge solution would be to add this line as the **last** line of your Click event code... SendKeys "{ESC}" but I see nothing wrong with the "select a cell" method where you would make this your **last** line of code... ActiveCell.Select Rick |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
Thanks Ron
"Ron de Bruin" wrote in message ... Hi ADK See the TakeFocusOnClick property of the button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ADK" wrote in message ... After the user clicks the command button and the code executes, the button is still focused. In code I only know to place Range("A7").Select to unfocus the button. Without this line the button remains focused. If you press the Esc key it unfocuses. I would like the result to be similar to the Esc key with having to select a cell. Possible? How? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Buttons
You had a response at your other post.
ADK wrote: After the user clicks the command button and the code executes, the button is still focused. In code I only know to place Range("A7").Select to unfocus the button. Without this line the button remains focused. If you press the Esc key it unfocuses. I would like the result to be similar to the Esc key with having to select a cell. Possible? How? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command buttons | Excel Programming | |||
Command buttons etc | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming | |||
Command buttons not available | Excel Programming |