hi there

can anyone tell me where to define the shortcut for a macro/sub (in the
VB editor)? is it possible at all this way?

thanks

fabalicious


---
Message posted from http://www.ExcelForum.com/

Look at VB help for "OnKey Method".

Mike F
"fabalicious " wrote in message
...
hi there

can anyone tell me where to define the shortcut for a macro/sub (in the
VB editor)? is it possible at all this way?

thanks

fabalicious


---
Message posted from http://www.ExcelForum.com/

Thanks.

...that tells me HOW. what I still don't know is WHERE to defin
this!?



--
Message posted from http://www.ExcelForum.com

Hello. If I understand your question...
On the Worksheet, hit Alt+F8.
Select your macro from the list.
Click "Options"

You wouldn't be the first to look for the macro shortcut key assignment from
the vba editor. :)

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"fabalicious " wrote in message
...
Thanks.

..that tells me HOW. what I still don't know is WHERE to define
this!?

F


---
Message posted from http://www.ExcelForum.com/

nice!
...and straight forward actually. I was looking for it in the editor
sometimes you just don't see the obvious

--
Message posted from http://www.ExcelForum.com