Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have an .xla add-in that is opened but not loaded (not ticked under Tools,
Add-ins). In the Workbook_Open event I run a Sub to create a menu and this Sub sets some keyboard shortcuts like this: Application.OnKey "^+v", "Macro1" Macro1 is in a normal code module. When I do the keyboard shortcut I get the exact message: The macro "C:\ExcelAddins\Reporting.xla'!Macro1' cannot be found. I also tried to fully set the macro like this: Application.OnKey "^+v", "Reporting.xla!Module1.Macro1" But same result. The file is present in the folder, the .xla file is open,the macro is present in a normal module, so what causes the above message? I had this working fine before and no idea why it is not now. Thanks for any advice. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.OnKey during Copy mode | Excel Programming | |||
Application.OnKey | Excel Programming | |||
Application.OnKey problem | Excel Programming | |||
application.onkey doesn't work | Excel Programming | |||
Application.OnKey problem | Excel Programming |