can i assign hot keys to vba sub? i have been trying throught the macr
thing on an existing sub but it doesn't take

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

Tools / Macro / Macros / Select Macro and then hit the Options button and put in
the shortcut you want

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"ksnapp " wrote in message
...
can i assign hot keys to vba sub? i have been trying throught the macro
thing on an existing sub but it doesn't take.


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

that doesn't wor

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

and that is not particularly helpful. What does "doesn't work" mean - do
you get an error, nothing? a crash?

What keys are you trying to assign? Where is your macro stored?


In article ,
ksnapp wrote:

that doesn't work

sorry i could have been more specific. it just sits there, nothin
happens when i hit the assigned key combinatio

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

In article ,
ksnapp wrote:

sorry i could have been more specific. it just sits there, nothing
happens when i hit the assigned key combination

Try putting a breakpoint in your code to see if it's getting called.