Thread: Command Buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?