Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons
Is there a keyboard shortcut for selecting and activating certain command
buttons on my spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons
Open the Control Toolbox and click the Design command button (the button
w/the triangle, pencil & ruler). Select the command button of your choice and then right click on the selected button. Select Properties from the short-cut menu. In the list of properties locate the Accelerator property and enter the letter you want to be the hot key. The letter must by one of the letters used by the button's caption. Exit design mode, save the workbook. To activate the command button press Alt + Your Letter Designation -- Kevin Backmann "Hoyas07" wrote: Is there a keyboard shortcut for selecting and activating certain command buttons on my spreadsheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Buttons
Thanks for the response. I had tried that before, but my problem is I have
multiple buttons in multiple spreadsheets. I was wondering if there was a generic way on the keyboard to activate the button (a way to click on it using the keyboard instead of the mouse). Thanks again. "Kevin B" wrote: Open the Control Toolbox and click the Design command button (the button w/the triangle, pencil & ruler). Select the command button of your choice and then right click on the selected button. Select Properties from the short-cut menu. In the list of properties locate the Accelerator property and enter the letter you want to be the hot key. The letter must by one of the letters used by the button's caption. Exit design mode, save the workbook. To activate the command button press Alt + Your Letter Designation -- Kevin Backmann "Hoyas07" wrote: Is there a keyboard shortcut for selecting and activating certain command buttons on my spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons Disappear | Excel Discussion (Misc queries) | |||
Excel Command Buttons | Excel Worksheet Functions | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Help with command buttons | Excel Worksheet Functions | |||
command buttons | Excel Worksheet Functions |