Excel/VBA Connect a Button with an Shortcut
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
Re: Excel/VBA Connect a Button with an Shortcut
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