Click to See Complete Forum and Search --> : Excel/VBA Connect a Button with an Shortcut


Akademos
April 12th, 2001, 03:52 AM
Hi,
here's a easy question for the most of you ;-). I add a Button in a Excelsheet. How to i connect this with a key shortcut? I tried to do it the same way as in VB (add a '&' ín the caption property) but it didn't work. can anyone help me please

thanks

akademos

coolbiz
April 12th, 2001, 09:46 AM
Right click on the button and choose PROPERTIES from the POPUP MENU.

If the caption on the button is "SHUTDOWN" and you want ATL+S to activate it, then set the ACCELERATOR property to S.

-Cool Bizs