Shortcuts not working in Excel 2010

Add-in Express™ Support Service
That's what is more important than anything else

Shortcuts not working in Excel 2010
 
OliverM




Posts: 144
Joined: 2015-08-13
I added some ADXKeyboardShortcut components to my project. They nicely work if I test with Excel2013 but do not when triggered in Excel2010.
Kind regards
Oliver
Posted 12 Dec, 2016 10:33:32 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Hello Oliver,

I can't reproduce the issue using Add-in Express 8.4 and Excel 2010 14.0.7173.5000 32bit.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 13 Dec, 2016 04:54:48 Top
OliverM




Posts: 144
Joined: 2015-08-13
Hi Andrei,

I have both office versions installed on the same machine. Could this maybe cause the issue?
Kind regards
Oliver
Posted 13 Dec, 2016 06:38:29 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Oliver,

This may influence the issue but first I would turn off all other COM add-ins and intercept Ctrl+A. Does it work?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 13 Dec, 2016 06:51:54 Top
OliverM




Posts: 144
Joined: 2015-08-13
I created a test add-in with an ADXKeyboardShortcut intercepting Ctrl+A.
I tested with all other add-in's turned off and it works fine with 2013 but not with 2010.
To be sure it is a double installation issue only (2010 was added last), I will remove 2013 from one of the test machines. I'll let you know about the result.

Next I added an ADXKeyboardShortcut intercepting Ctrl+A to my main project to test which shortcut fires if 2 add-in's are using the same shortcut. The test add-in always won, even if manually loaded after the main add-in. Could it be that internally the add-in's name is a criteria if the decision is to be made which add-in executes the shortcut?
Kind regards
Oliver
Posted 13 Dec, 2016 07:39:20 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Oliver,

OliverM writes:
2010 was added last


This *is* the cause of the issue! Microsoft recommends installing Office versions in their natural order; see https://support.microsoft.com/en-us/kb/2784668.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 13 Dec, 2016 08:41:59 Top
OliverM




Posts: 144
Joined: 2015-08-13
I wish I could confirm adding Office 2010 after 2013 is the reason but it seems to be not.
What I did for testing:

- Identified a test machine only having 2013 installed (Test_A)
- Identified a test machine having both versions installed with 2010 added after 2013 (Test_B)
- Cleaned Test_B using the provided uninstaller according to this site
- Checked successful uninstall by manually working through registry and file system according to this site
- Installed Office 2013 on Test_B (15.0.4433.1508)
- Cleaned Test_A using the provided uninstaller according to this site
- Checked successful uninstall by manually working through registry and file system according to this site
- Installed 2010 on Test_A (14.06.112.5000)
- Created test add-in with 2 ADXKeyboardShortcut components (Ctrl+F12 and Ctrl+A)
- Test add-in shortcuts work on Test_B but do not on Test_A

- OS in use is Win 8.1
Kind regards
Oliver
Posted 14 Dec, 2016 09:41:48 Top
OliverM




Posts: 144
Joined: 2015-08-13
Any news on the issue, Andrei?
Kind regards
Oliver
Posted 16 Dec, 2016 09:28:26 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Hello Oliver,

Will it work if you install all updates on Office 2010?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 16 Dec, 2016 10:03:14 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
I can't reproduce the issue on a machine with Excel 2010 (14.0.7173.5000 32bit). Unlike the machine mentioned in my previous post, this machine have never had any other Office versions installed.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 16 Dec, 2016 10:13:08 Top