Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Finally solved this problem.
It had to do with the fact that another open workbook had a Sub with the same name. Not sure how this could cause trouble as the workbook was specified with the OnKey. Also didn't come across this possibility in my searches, but pleased this is solved. RBS "RB Smissaert" wrote in message ... 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 |
Reply |
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 |