Add-In Keyboard Shortcut
Peter,
When I do this, and get rid of the menu already in place (but run your code)
I get an error:
The macro" C:\..\AddIns\personal.xla'!AddMenu' cannot be found
do you what this means?
Thanks,
-m
"Peter T" wrote:
Application.OnKey "+^D", "MyMacro"
This should create a shortcut Shift-Ctrl-D. If there's any possibility
MyMacro may exist in any other workbook prefix with ThisWorkbook.Name & "!".
Call it from an Open event.
Not sure about naming your addin "Personal.xla" if there may also be a
Personal.xls open, guess it's OK but I wouldn't.
Regards,
Peter T
"mvyvoda" wrote in message
...
i am using an add-in to store macro's ("personal.xla" in C:\Documents and
Settings\mvyvoda\Application Data\Microsoft\AddIns). I need to have a
keyboard shortcut to one fuction within this add-in. The macro list
(Alt-F8)
does not list any macro's in personal.xla.
i'm not even sure where to start.
thanks,
-m
|